strange behaviour with " in CSV

[#1]

Hi to all, I'm facing a strange problem importing data from a CSV.

If some rows contains " in a description column, after the import some rows are not correctly loaded in QlikView.

After removing only the character " replacing it with blank all works fine.

I'm import data from csv with the following statement

My_TAB:

LOAD

DATACAL as DateID,

ID_CDR as ID_CDR_MP,

ID_INTERVENTO AS ID_INTERVENTO_MP,

DENOMINAZIONE as DENOMINAZIONE_MP,

DESC_SUBS as PIANO_MP,

DATAINIZIO as DATAINIZIO_MP,

DATAFINE as DATAFINE_MP,

USERNAME as USERNAME_MP,

NOME as NOME_MP,

COGNOME as COGNOME_MP,

SOCIETA as SOCIETA_MP,

ESEGUITO as ESEGUITO_MP,

CONFORME as CONFORME_MP

FROM

MAN_PROG.csv

(txt, codepage is 1252, embedded labels, delimiter is ';', msq);

Can someone help me to identify the problem?

Best regards

Fabrizio

[Gysbert_Wassenaar · Accepted solution]

Try setting the Quoting to None. That way quotes won't be regarded as start/end tags of string values.