Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
EV89
Contributor III
Contributor III
‎2021-05-28 04:05 AM

Error parsing csv with internal double quote \"

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

Labels (2)
Labels
392 Views
0 Likes
1 Reply
gjeremy1617088143
Master
Master
‎2021-05-28 04:11 AM

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

392 Views
0 Likes