topic Re: Double quote import csv interrup string partially imported in database in Talend Studio

Double quote import csv interrup string partially imported in database

EV89 — Fri, 24 Jul 2020 08:20:41 GMT

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

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

Re: Double quote import csv interrup string partially imported in database

TRF — Fri, 24 Jul 2020 08:26:56 GMT

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")

Re: Double quote import csv interrup string partially imported in database

EV89 — Fri, 24 Jul 2020 11:00:07 GMT

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.

Re: Double quote import csv interrup string partially imported in database

EV89 — Fri, 24 Jul 2020 14:54:01 GMT

useful links i have found related this topic:

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