Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Maybe this is helpful:
Re: STORE Into txt-file with double quotes
Store in CSV without double quotes
- Marcus
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