How to Filter filelist

[#1]

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)

[rwunderlich]

In your For Loop:

IF (NOT WildMatch('$(FoundFile)','*CAT*')) THEN

   LOAD etc

ENDIF

-Rob

[#3]

Very helpful, thanks rwunderlich‌.