topic Re: Storing into CSV with Comma and Double Quotes in QlikView

Storing into CSV with Comma and Double Quotes

ryanfoster84 — Mon, 26 Jan 2026 18:19:17 GMT

Hi,

I need to store my results into a CSV file and have the comma separator and double quotes like the example below:

A,B,C,D,E,F,G,H,I,J,K,L,M

"C","CO","CT","F","A","seed","38","T","F","F","6","6","1"

Currently when I export to CSV using this:

STORE PROD INTO $(vExtData)ref_prod.csv(txt);

DROP TABLE PROD;

I get the following output

A,B,C,D,E,F,G,H,I,J,K,L,M

C,CO,CT,F,A,seed,38,T,F,F,6,6,1

is there away to get the desired results

kaushiknsolanki — Wed, 05 Sep 2018 09:52:28 GMT

Hi,

Try this.

Load ' " '& Field1 & ' " ' as Field1,

' " '& Field2 & ' " ' as Field2

From XYZ;

Then normal Store command.

Regards,

Kaushik Solanki

ryanfoster84 — Wed, 05 Sep 2018 12:41:05 GMT

hi,

no this does not work

A,B,C,D,E,F,G,H,I,J,K,L,M

"""C""","""CO""","""CT""","""F""","""A""","""seed""","""38""","""T""","""F""","""F""","""6""","""6""","""1"""

Miguel_Angel_Baeyens — Wed, 05 Sep 2018 13:34:12 GMT

Use the delimiters and options:

STORE Table INTO File.txt (ansi, txt, delimiter is \t); // for example

EDIT details in help site:

ryanfoster84 — Wed, 05 Sep 2018 13:45:24 GMT

I'm not to sure on this would you have an example of how to do this for my issue?

ryanfoster84 — Wed, 05 Sep 2018 15:28:27 GMT

thanks having read the material and tried numerous things I am still at a lose

Miguel_Angel_Baeyens — Mon, 10 Sep 2018 08:38:16 GMT

See attached on how to use the syntax to save TXT files with quotes.

I don't know your specifications so you will have to see which options best meet your needs.