Regex for variations of a phrase

[FreeRangeDingo]

I have a text column for comments (see example below), and I need to know (True/False) whether it contains the misrun or misfire.  Misrun and misfire can be spelled or annotated with special characters.  I currently have a contains formula trying to find all the different spellings, but I know this is not a good way to do it.  Note, misrun and misfire can occur anywhere in the string. 

I know I can use the Regex tool set to Match to give me the true/false, but I don't know enough regex to write it.  Help would be greatly appreciated.  Thank you.

[estherb47 · Accepted solution]

Hi @FreeRangeDingo,

Interesting challenge!

What about something along the lines of

Regex_countmatches([field],“mis.*run”)>0

For misfire and variants, try mis.*fire


Simplistic (and not on my computer to check), but should find all variations of both words.

The challenge that I’ve had with regex_match is that the contents of the entire field have to match the code. Regex count matches finds how many matches to a code are within a field.


Please let me know if that helps.

Cheers!
Esther

[FreeRangeDingo · Accepted solution]

@estherb47 this is the best solution so far.  I wasn't able to make the others work, so I was back with my super clunky contains formula.  That formula filtered out 172 records from my data set.  Your solution filtered out 173 without the clunk. I also learned something new about regex_match versus regex_countmatches.  Thank you very much!

[joshuaburkhow]

Oooooh that is slick! Nice one @estherb47 !