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
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