I have to import CSV files exported from a client MySQL database. They import smoothly with phpMyAdmin, Navicat or sqlMaestro - alas, PHPR has severe problems with multi line fields. See example below:
Aktenzeichen,
Antwortcode,
Anfragedatum,
Ergebnisdatum,
Auftragsnummer,
Anfragekennziffer,
Nettopreis,
Umsatzsteuer,
Bruttopreis,
Auskunft_1,
Auskunft_2,
Auskunft_3,
Auskunft_4,
Auskunft_5,
Auskunft_6,
Auskunft_7,
Auskunft_8,
Auskunft_9,
Auskunft_10,
Auskunft_11,
Auskunft_12,
Auskunft_13,
Auskunft_14,
Auskunft_15,
Anfrage_1,
Anfrage_2,
Anfrage_3,
Anfrage_4,
Anfrage_5,
Anfrage_6,
Anfrage_7,
Anfrage_8,
Anfrage_9,
Anfrage_10,
Anfrage_11,
Anfrage_12,
Anfrage_13,
Anfrage_14,
Anfrage_15,
Anfrage_16_1,
Anfrage_16_2
Data:
"BI280035","EP2","08.07.2008","18.07.2008","214275","24145350","3,90","0,74","4,64","","",
"firstname","lastname","","street","1","","","44444","city","","0","16.05.1983","","m","","firstname","lastname","",
"street","38","","1. floor","55555","city","","0","16.05.1983","
[color=#FF0000]carriage return
and linefeed
The red marked lines are one field. As soon as the CRLFs are removed, the import works perfectly.
How can I achieve an import where multi line fields are treated correctly and the same way the other apps mentioned above do?
Thanks.