Re: Detecting line terminators in a CSV file

2006-07-03 Thread Daniel Kasak
John W. Krahn wrote: > Daniel Kasak wrote: > >> John W. Krahn wrote: >> >>> perldoc -f binmode >>> >> binmode is what I was after - thanks :) >> > > Then don't forget to use the correct characters for this: "\015" for Carriage > Return and "\012" for Line Feed; as using "\n" may

Re: Detecting line terminators in a CSV file

2006-06-30 Thread John W. Krahn
Daniel Kasak wrote: > John W. Krahn wrote: >> >>Are you sure that you want to "fix" this? > > Certain. I need to find the correct line terminator, and then tell MySQL > what it is. > >>perldoc -f binmode > > binmode is what I was after - thanks :) Then don't forget to use the correct characte

Re: Detecting line terminators in a CSV file

2006-06-29 Thread Daniel Kasak
John W. Krahn wrote: > Because when on Windows the CR LF pair is converted to the "\n" > newline character. > perldoc PerlIO > [snip] >:crlf >A layer that implements DOS/Windows like CRLF line endings. On >read converts pairs of CR,LF to a single "\n" newline chara

Re: Detecting line terminators in a CSV file

2006-06-29 Thread John W. Krahn
Daniel Kasak wrote: > Greetings. Hello, > I'm trying to write a CSV import routine for MySQL ( possibly will > extend it with a flashy GUI and release open-source ). > > I'm having great difficulty doing this under Windows. If I use the code > below under Linux, it works perfectly, detecting cor