Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have this file.csv, and when I load it into QlikView it keeps a lot of quotation marks (""Field_Name""), and I see them when I recharge all the data.
How can I get rid of this?
Thank you very much.
Hi Juan,
Make sure you mark the "MSQ" quoting style in the wizard that apperas when you click on the "Table File..." button in the Edit Script window. You may need to use the PurgeChar() function on the fields to remove additional double quotes signs:
Table:
LOAD PurgeChar(FieldName, '"') AS CleanFieldName
FROM file.csv
(txt, codepage is 1252, embedded labels, delimiter is ';', msq);
Hope that helps.
Miguel
Hi Juan,
Make sure you mark the "MSQ" quoting style in the wizard that apperas when you click on the "Table File..." button in the Edit Script window. You may need to use the PurgeChar() function on the fields to remove additional double quotes signs:
Table:
LOAD PurgeChar(FieldName, '"') AS CleanFieldName
FROM file.csv
(txt, codepage is 1252, embedded labels, delimiter is ';', msq);
Hope that helps.
Miguel
Hi,
You can remove double quotes from a specific field using
PurgeChar(FieldName, Chr(34) )
int the load statement.