store Table into Data.bat(txt);
When I am trying to load the data into a txt file double quotes is getting added along with that.
If the original contains something like below.
When it stores it into a txt file. It stores something like below.
How can I eliminated double quotes when storing it in a text file. Please help!
Did anyone find an answer to this one? In the past I have got around the problem by doing the store with a FileSystemObject write in a macro - but I've another case come up when I would much rather use a store on load.
Any suggestions welcome!
As it happens the data is coming from Excel - but I'm not sure why that would affect the output?
When I get a chance I will give this a go. Thanks for the input!
It happens with all the fields?
Before the Store, try erasing the ", with replace, like:
replace (text_field, '"', '') (first parameter, the field; second, doble quotes between single quotes; last parameter, only a pair of single quotes)
And then Store it.
The issues only occur when I have a comma or quote symbol in the data. QlikView tries to make things into a valid CSV file by quoting the values. The issue is though that I am writing out an HTML file with data in, so the quotation marks I have in the code are critical. Removing them as you suggest, with a Replace, would render my HTML incorrect.
It feels like there should be parameters to the STORE statement that would handle this - but I've not managed to hit upon the correct syntax yet.
I'm afraid the marco was written on site for a client so I don't have access to it, or to anything similar on hand.
It used the FileSystemObject and the Write statement. You should be able to find something similar if you search. You could try using the search on http://askqv.com/ to see if that turns up any suggestions.
In my case, once I open the data in csv, I see the double quotes in the original file. Excel seems to hide double quotes that start and end texts.