Specific Word in first 50 characters

[Daniel1908]

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.

[tresesco]

Try like:

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

Now and/or combination is up to you.

[Daniel1908]

Thanks for your help.