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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Double quote in a .csv file

Dear all,

I need your help with a problem of loading a csv file.

Indeed, there is on one of my lines a double quote character which is not closed by a second double quote.

The problem is that I can not load the lines after the line containing the double quote.

I tried to remove the double quote with the purgechar function but no result.

I use for my loading => FROM $(vFile) (ansi, txt, delimiter is ';', no labels,  msq);

Thank you for your feedback

Ben

0 Replies