Discussion Board for collaboration regarding Qlik Connectors.
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
COMMIT:LOAD DummyCommit AS '--Insert_Statement' INLINE[DummyCommit'Commit;''EXIT''Bala's'];
Any inputs on the above query?