Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
What is the best method to exclude files with a specific name? For example if I have a script that wants to loop through a folder picking up every file EXCEPT a file that includes the word 'CAT', how can I do it?
'CAT.xlsx' doesn't get loaded
'Dog.xlsx' does
Wombat.xlsx does
...
I'm attempting to loop using:
for each FoundFile in filelist( Root & '\*.' & FileExtension)
In your For Loop:
IF (NOT WildMatch('$(FoundFile)','*CAT*')) THEN
LOAD etc
ENDIF
-Rob
Very helpful, thanks rwunderlich.