get part of a string and exclude record

QFanatic — Thu, 28 Oct 2021 10:21:32 GMT

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

Re: get part of a string and exclude record

abhijitnalekar — Thu, 28 Oct 2021 10:41:19 GMT

Hi @QFanatic ,

Please try the below expression.

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

Re: get part of a string and exclude record

QFanatic — Thu, 28 Oct 2021 11:13:50 GMT

thank you!

topic Re: get part of a string and exclude record in App Development

get part of a string and exclude record

Re: get part of a string and exclude record

Re: get part of a string and exclude record