Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

juan_escobar
Contributor II

Loading .csv

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.

Tags (1)
1 Solution

Accepted Solutions

Re: Loading .csv

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

2 Replies

Re: Loading .csv

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

Not applicable

Loading .csv

Hi,

You can remove double quotes from a specific field using

PurgeChar(FieldName, Chr(34) )

int the load statement.

Community Browser