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