Link to home
Start Free TrialLog in
Avatar of soco180
soco180

asked on

How to use Regular Expression to identify a string containing the word ATB and does not contain the word MEDICAID and ends with XLS

I need to use Regular Expressions to identify file names by this criteria:
  1 contains the word ATB
  2 does not contain the word MEDICAID
  3 ends with XLS
  4 search pattern is case insensitive.
ASKER CERTIFIED SOLUTION
Avatar of ddrudik
ddrudik
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
^(?i:)(?!.*MEDICAID).*ATB.*XLS$
Avatar of soco180
soco180

ASKER

That was exactly what I needed. Thanks for the quick response, I really appreciate it!
Thanks for the question and the points.