Qlik Community

Qlik Connectors Discussions

Discussion Board for collaboration regarding Qlik Connectors.

Highlighted
Balasubramanian
New Contributor II

STORE Command Additional Double Quotes

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

1 Reply
Highlighted
Balasubramanian
New Contributor II

Re: STORE Command Additional Double Quotes

@Darren_Ball ,

Any inputs on the above query?