Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi
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
Hi
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
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
Hi
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
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:
In particular the BNF section, but maybe some of the others help here too...
Regards,
Brett