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

CoG

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