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
I would suggest having a look at the following Design Blog post which explains quotes in the product and will hopefully get you the info you need:
https://community.qlik.com/t5/Qlik-Design-Blog/QlikView-Quoteology/ba-p/1476029
Regards,
Brett