STORE Comman Additional Double Quotes

Balasubramanian — Sat, 16 Nov 2024 19:11:11 GMT

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

Re: STORE Comman Additional Double Quotes

Brett_Bleess — Tue, 03 Mar 2020 19:49:19 GMT

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:

Regards,
Brett