Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

bnoailly
New Contributor

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

Community Browser