Hi,

If I use "//" instead of "/"" as text enclosure nothing is imported from the csv file.

Jérôme

Hi,

Here a sample of the data extract from the cvs file:
\Le Canto del Gallo\" se trouve sur les hauteurs de Ranedo de Curueñon

and the result in mysql table:
\

Best regards

Jérôme

Hi,

In a job i am importing data from a cvs file into a mysql table. When I run the job (without error) and look after at the data in the mysql table, I find that the data imported from one of the cvs field is truncated in mysql row every time there is a \ sign.
The format of the cvs file is:
• Separator: semicolon (;)
• Field delimiter: double quotation marks (")
• Double quotation marks in data fields are escaped (\")
• UTF-8 encoding
so on the input side when I have edited the input file metadata I have chosen:
field separator: ;
row separator : \n
escape char settings : cvs --> escape char \" and text enclosure \"

Is there anything wrong in my parameters ? How can I import all the data ?

Thanks in advance for your help.

Cheers.

Jérôme