Weird CSV problem

[Anon]

Hi,

I have a csv file supplied by a customer that requires importing into a database. I can do that bit successfully.

However the file supplied does not have a /n at the end of each line. It appears to have a carriage return but not a new line so when the data is imported using my php script I get 1 line of data with the last field containing a string with the remaining contents of the csv in it.

If I open the file in somthing such as textpad or even excel, then save it, the import works fine.

I guess I need to open the CSV, do a find and replace on /n to change it to /n/r but I don't know how.

Can someone please help.

Deano

[Anon]

hey
this was rubbish

[Anon]

can't you tell php to look for a \r and not a \n? Send me the file and i will convert the \r to \n using perl.

[Anon]

Thanks for the feedback.

Solved the problem by using:

$string = ereg_replace("\r\n", "\n", $string);

Thanks