I am trying to write a qlikview script that (amongst other things) moves a group of files from one place to another. The general idea is that in the script I generate lines of cmd commands (MOVE [from] [to]) in a table. Then I want to export this table using:
Store [::CMD] FROM cmdtable INTO .\batchfile.bat (txt);
However, the problem is that my [from] and [to] filepaths contain white spaces. In cmd script this is solved by surrounding the path with double quotes:
MOVE "C:/Some Dir" "C:/Other Dir"
However, when I write a line like above to txt using the store command, the output looks like this:
"MOVE ""C:/Some Dir"" ""C:/Other Dir"""
Anybody has an idea how I can force qlikview to write to file without escaping? Any help is appreciated!
So the STORE INTO command automatically escapes all the qoutes and als escapes the entire row. I want to just write the plain string without the automatic escaping, so my question is: how do I make the STORE INTO command stop escaping the output?
The linked qlik tips blog is almost the exact solution I have right now, but that code does not work when your file paths contain blank spaces or other characters that need to be escaped...