topic Error parsing csv with internal double quote \" in Talend Studio

Error parsing csv with internal double quote \"

EV89 — Fri, 28 May 2021 08:05:50 GMT

Hi,

im tryng to import a csv, but i fidn out a row as below:

"Bakoleva","ul. \"Brus Taelov\" 8, et 5, Kiavilnoka, Sofia",NULL,"Sofia",1808,"BG"

\" before and after Brus Taelov is recognized as field delimtier and break the column in a bad way. Any workaround for this problem?

thanks for your help

gjeremy1617088143 — Fri, 28 May 2021 08:11:51 GMT

Hi it seems comma is your field delimiter, so if you use comma in the delimiter options you will not have any problem to parse it.

but it seems "ul. \"Brus Taelov\" 8, et 5, Kiavilnoka, Sofia" is one field with comma inside