You are not logged in.
Sorry I have tried now using "\\" as the escape char and that works !
thanks for your help.
If I use "//" instead of "/"" as text enclosure nothing is imported from the csv file.
try to use \\" instead of \"
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:
Please show us an example of your data and what are your expected result?
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.