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

AyCe1082 — Sat, 16 Nov 2024 18:16:50 GMT

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

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

rubenmarin — Sat, 01 Aug 2020 11:14:40 GMT

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";

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

AyCe1082 — Sat, 01 Aug 2020 13:44:23 GMT

That worked perfectly thank you.

topic Re: Using cmd.exe in load script where the filepath includes a space in QlikView

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

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

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