get part of a string and exclude record

[QFanatic]

hi,

PFA

I've been asked to read data and exclude where the word 'form' appears alone in a string. My problem is that 'form' appears in different ways - it could be part of a surname, or Platform (like big data Platform in the example) or as a separate entity.

The rule that needs to be applied..

Exclude ANYTHING that excludes the word ' form ' in the name (note spaces).  however, there are 2 records for Brad Forman. I want to EXCLUDE the one that is consistent with the rule, and KEEP the one that only contains 'Brad Forman'.

How do I do this?

Thanks

[abhijitnalekar · Accepted solution]

Hi @QFanatic ,

Please try the below expression.

=if(SubStringCount(upper(Field_name),' FORM '),'Exclude','Include')

[QFanatic]

thank you!