topic Specific Word in first 50 characters in App Development

Specific Word in first 50 characters

Daniel1908 — Fri, 25 Jun 2021 08:27:09 GMT

Hello Together,

I am using the below expression, it works fine.
Now I want to show the Material which does not contain the Text = *Spare Part* in the first 50 characters as well.
If *Spare Part appears in the first 50 characters it should not appear in the list.

=Count( {Product={'AW'},[Status]*={'Good'},Text-={"*Spare Part*"}>+<[Status]*={'Very Good'},Text-={"*Spare Part*"}>}Material)

Thanks for your help.

Re: Specific Word in first 50 characters

tresB — Fri, 25 Jun 2021 09:04:29 GMT

Try like:

Text={"=WildMatch(Left(Text,50), '*Spare Part*') "}

Now and/or combination is up to you.

Re: Specific Word in first 50 characters

Daniel1908 — Fri, 25 Jun 2021 13:01:02 GMT

Thanks for your help.