Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi.
I'm trying to get an export job to work, so that the field names and field values will be exported with double quotes:
I used Chr(39) and made the structure in the qvw-file - and it is as it should be, that is:
Field names (with double quotes in the name):
"Date"
"Amount"
and field values (with double quotes in):
"2012-01-01"
"1000"
but when exporting the table to a txt-file by the use of STORE qlikview adds another set of double quotes, and the result is:
Field names:
"""Date"""
"""Amount"""
Field values:
"""2012-01-01"""
"""1000"""
Why is that, and how can I get QV to skip the double double-quoting. (Using the Format Specification Items is not working for me).
Hey
I am also looking for the same. By any chance have you got the solution? Please share if you have got any solution.
Thanks,
qvforum