topic Re: Using FOR EACH ... DIRLIST to iterate through multiple folders using wildcards in QlikView

Using FOR EACH ... DIRLIST to iterate through multiple folders using wildcards

tschullo — Wed, 25 Nov 2020 16:16:04 GMT

In the script below, note that there are spaces in the folder path saved as vFileQVD below.

When I run the script, the dirlist command fails. If I take out the spaces, it works ok.

LET vFileQVD = '\\hbsvr.adroot.myBiz\root\Download\GBL DOG - CAT';
for each Dir in dirlist($(vFileQVD)&'\*')
TRACE $(Dir);
Next Dir
exit script;

How should I wrap the string so I don't get an error?

Re: Using FOR EACH ... DIRLIST to iterate through multiple folders using wildcards

m_woolf — Wed, 27 Feb 2019 20:38:55 GMT

apostrophes work for me.

Re: Using FOR EACH ... DIRLIST to iterate through multiple folders using wildcards

tschullo — Wed, 27 Feb 2019 20:52:46 GMT

for each Dir in dirlist('$(vFileQVD)' & '\*')

OK, thanks, that worked.