STORE Comman Additional Double Quotes

[Balasubramanian]

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

[Brett_Bleess]

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