topic How to remove double quotes when storing table in a text file? in QlikView

How to remove double quotes when storing table in a text file?

Wed, 03 Sep 2014 13:43:40 GMT

Hello Friends,

I need to print all my Fields in a text file in the format below:

"Field1","Field2","Field3", . . . . . .

I load my table in this way:

mytable:

LOAD

chr(34)&'tex1t'&chr(34) as FIELD1,

chr(34)&'text2'&chr(34) as FIELD2,

...

Then I am storing my table in this way:

STORE * from mytable into

(txt, codepage is 1252, no labels, delimiter is ',' ,no quotes);

All the fields into myfile.txt file results like that:

"""Field1""","""Field2""","""Field3""", . . . . . .

If when I load fields I leave out the " chr(34) " , the fields into myfile.txt would be:

Field1,Field2,Field3, . . . . . .

Is anyone able to help me?

Thanks a lot

Mirco

marcus_sommer — Wed, 03 Sep 2014 14:35:16 GMT

Maybe this is helpful:

- Marcus

Anonymous — Wed, 03 Sep 2014 14:37:36 GMT

you can force qlikview to write the quotes in the text file by adding

LOAD

'tex1t'& chr(10) as FIELD1,

'text2'&chr(10) as FIELD2,

you don't need chr(34) then but it adds line feeds to you field values. why do you need the quotes?

best regards

Stefan