Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi @QFanatic ,
Please try the below expression.
=if(SubStringCount(upper(Field_name),' FORM '),'Exclude','Include')
Hi @QFanatic ,
Please try the below expression.
=if(SubStringCount(upper(Field_name),' FORM '),'Exclude','Include')
thank you!