Double quote import csv interrup string partially imported in database

[EV89]

Hi Talend Gurus,

I had a problem importing a string field from csv in mysql.

i have a csv like:

1;"0X0X0.X10";"Blocked";"Y";"N";"BOX";"";"";"BOX FOR SHIPPING "V" SHAPE"

If i see what value has been imported in Description column in MySql instead of BOX FOR SHIPPING "V" SHAPE

or

BOX FOR SHIPPING V SHAPE

( i set up double quote as escape in my input file options) i see

BOX FOR SHIPPING

.

I have csv options enabled in my tinputdelimited file. Have you some suggestion to deal this problem?

thanks for your help

[TRF]

Change Text enclosure from " (the standard) to something else (of your choice) or protect included quotes when contained in field values ("BOX FOR SHIPPING \"V\" SHAPE")

[EV89]

Hi Trf, thanks for your reply

Unfortunely i am not the man who made the csv export so i searching for a method i can do myself with talend.

Another curious things is that if i set up text enclosure as "\"" and Escape character as """. Talend recognize thhe initial double quote as text enclosure but not the inside " as escape.

[EV89]

useful links i have found related this topic:

https://stackoverflow.com/questions/43512095/usage-of-escape-char-and-text-enclosure