Exlcude Records from filter where Name contains "LTD" or "PLC"

[Masond3]

All, 

I have Friday brain fog., 

I have a column called "names" and all i want to  apply an filter which  excludes any names which contain "PLC" or LTD"

I have applied the following custom filter : !Contains([Names],"PLC, LTD")

However its still returning records with those names through the  "true" Output, When i would expect these to be coming through the "False" Output 

Regards
Masond3

[AndrewDMerrill]

As it is written, your filter is for the block of text "PLC, LTD" so "PLC" and "LTD" will pass right through.

You can do !Contains([Names],"PLC") && !Contains([Names], "LTD")

I'd need to think a little more if there is an even better way...

I just thought a little more and you can also filter on REGEX_Match([Names], ".*(PLC|LTD).*")!=-1