Using cmd.exe in load script where the filepath includes a space

[AyCe1082]

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

[rubenmarin · Accepted solution]

Hi, have you tried?:

EXECUTE cmd.exe /c dir /s "D:\QlikView\LIVE\REPORTS\Reports\Match_Report\Test Folder A 2019-2020" > "D:\QlikView\LIVE\REPORTS\Reports\Match_Report\filelist_ORA1.txt";

[AyCe1082]

That worked perfectly thank you.