Using cmd.exe in load script where the filepath includes a space
Hi all, I need to modify a working cmd to specify a folder for a test I am running but the folder has a space so the text file isn't being populated. The actual name of the folder cannot be changed.
The lines are
set vFile = "Test Folder A 2019-2020";
EXECUTE cmd.exe /c dir /s D:\QlikView\LIVE\REPORTS\Reports\Match_Report\$(vFile) > D:\QlikView\LIVE\REPORTS\Reports\Match_Report\filelist_ORA1.txt;
But I also tried without the variable and just had that folder name in its place.
I read on stackexchange that adding " " for the folder with the space should work but it doesn't work in QV (that's why I tried to use the variable as well but that doesn't render the quotes in the actual execute line). Does anyone have an idea how I can format this properly? The original line that is currently used is what is above but it ends at Match_Report\.