Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
Whenever i have a line containing a single quote in the text of a resident table,
On using a STORE INTO filename.txt(txt) it gets wrapped by an additional double quote at the start and end .
How do i get rid of this additional double quote ?
I have already used windows powershell to get over this double quotes
however when there are 2.4 million records having single quotes it takes 6 hours to remove the double quotes from the text and write to a new file.
I am looking at an option where the double quotes are not appended when storing into text file from Qlikview
Input:
COMMIT:
LOAD DummyCommit AS '--Insert_Statement' INLINE
[DummyCommit
'Commit;'
'EXIT'
'Bala's'
];
Output:
Commit;
EXIT
"Bala's"
Expected Output:
Commit;
EXIT
Bala's
Any inputs on the above query?
I think this might be the expected behaviour, e.g. reading this:
https://community.qlik.com/t5/QlikView-App-Development/Store-table-in-to-txt/m-p/1606981
It suggests that it is common behaviour when writing a CSV file to wrap any strings which contain 'special characters' in quotes to avoid confusing other systems which may read them.
This probably doesn't help you and I would be happy to be proven wrong and that there is a solution here.
Is this causing you an issue for reading these files into other downstream systems or are you having trouble loading them back into Qlik (in which case maybe you could try 'qvd' instead of 'txt' as the format?).
The only less than ideal workaround I could suggest is using the replace function to either remove the apostrophe or replace it with something else e.g. `.