Search text field with Wildcard

[ryan_b_fiting]

Hello Community - 

I am looking for some help when searching a text field.  I am trying to use an IF formula to search the text field that contains certain strings.  For the most part this works, but my issue is there I need to be able to search for a string "light - N Ounces" where N could be any number of ounces between 1 and 164.  I cannot seach for 'light' only, because that string occurs within other areas in the text field.  But I need the 'light' to be immediately followed by the 'N ounces' text string to categorize it.

I am using the CONTAINSTRING function in my current formula as I am looking for other keywords already, but I cannot figure out how to identify a string that has a changing value within it.

Any help would be greatly appreciated.

Thank You

Ryan Fiting

[Nathaniel_C]

Hi @ryan_b_fiting ,

Glad this worked for you!

Nathaniel

[Nathaniel_C · Accepted solution]

Hi @ryan_b_fiting ,

Contains = IF(CONTAINSSTRING(max(stringSearch[Column1]),"light - *ounces"),"Yes", "NO")

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

[Nathaniel_C]

Hi @ryan_b_fiting , as you can see, using the wildcard "*" works.

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

[tamerj1]

Hi @ryan_b_fiting 

please provide some examples