topic Re: Store table in to *.txt in QlikView

Store table in to *.txt

Kunkulis — Sat, 16 Nov 2024 02:53:13 GMT

Hello,

I have scrip that loads and organize the date. In one point it puts all the data needed in one small table and then stores it in txt file:

store * from TABLE into C:\TABLE.txt (txt, delimiter is ';');

Now it works just fine, but for no reason it chooses to put some comments between these things - "".

Looking trough all the steps that data goes through, these things don't show up anywhere except for when it is stored in txt.

Is this a bug, or am I missing something in this process?

Re: Store table in to *.txt

atoz1158 — Mon, 29 Jul 2019 13:13:36 GMT

Normally in text files any string type field that contains characters that could mean something else, like the field delimiters, will be wrapped with " characters.

Regards

Adrian

Re: Store table in to *.txt

Kunkulis — Tue, 30 Jul 2019 11:14:20 GMT

Hi,

Thanks for the answer, looks like it is the solution.

The only thing is that, I saw in the comment, it had ";" and a double space that seemed out of place. By removing them, it didn't help. But once I removed all the symbols ; - ( ) , . and the double spacing, also replacing every space in with a comma and then replacing it back to space only then it removed the quotation marks from the txt file.

Do you have any idea why it was still putting it in the quotation marks?

BR,
Kunkulis

Re: Store table in to *.txt

atoz1158 — Tue, 30 Jul 2019 11:38:17 GMT

A lot of characters can have special meanings to various systems and because what ever method has been used in Qlikview does not know what the txt file is going to be used for it seems to play safe and puts the double quote character around any text that contains these sort of special characters as this is the most common way used to stop the characters being misread when the file is used for input.

Regards

Adrian

Re: Store table in to *.txt

Brett_Bleess — Wed, 21 Aug 2019 12:32:52 GMT

Hey guys, the following Design Blog post may shed a little further light upon things here, from a more official stance, there is a subsequent link at the bottom of the post to another post as well, but I thought this one might be a bit more pertinent in regards to what you were experiencing, hope it may help a bit more:

https://community.qlik.com/t5/Qlik-Design-Blog/Escape-sequences/ba-p/1469770

You guys are definitely on the right track with things. The only other thing of which I can think that is in play here would be the following:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/script-syntax.htm

In particular the BNF section, but maybe some of the others help here too...

Regards,
Brett