Regex for file iterator to exclude filename with certain strings

Matillion ETL
1

Familiar with regex but not a guru. Can't seem to get this to pull correctly from SFTP recursing folders. . Suggestions? _ what am i missing here?

 

regex:

.*/.*(!.* processed.*|!.*done.*|!.*bak.*)(.*/.*)

 

Pulls nothing.

 

Objective:

 

get these filenames:

xyz.txt, abc.csv, efg.csv

ignore or exclude filenames:

processed_xyz.txt, abc.done.csv, efg.bak

 

 

2

Also tried ^(?!processed|.bak|done).*$ and no correct results although it works on regex101.com