topic Re: STORE Command Additional Double Quotes in Connectivity & Data Prep

STORE Command Additional Double Quotes

Balasubramanian — Tue, 28 Dec 2021 20:11:41 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 Command Additional Double Quotes

Balasubramanian — Mon, 03 Feb 2020 16:10:03 GMT

@Darren_Ball ,

Any inputs on the above query?

Re: STORE Command Additional Double Quotes

chrisbrain — Tue, 10 Mar 2020 12:56:18 GMT

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. `.