Error parsing csv with internal double quote \"

[EV89]

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]

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