Find Month Name in String

[ferha_jafri]

Hello Experts,

I have a condition in which I want to check for month name in below string, please check below:

I below strings you find month name either full month name or MMM or month along with date. Can you help me how to find month names in strings.

ABSEP1901794
ABOCT1900069
CDSEP1903127
CDOCT1902012
CDFEB2002951
ABC : ODMAR2003690
Over DATE bal Apr
June over DATE
June OveRdate Balance
ABC : ODMAR2003541
ABOCT1900520
CDF : ODAPR2000881
CDF : ODMAR2004074
Overdate balance for April
fgh : ODMAR2004209
ODl April

Thanks in advance

[jdunkerley79 · Accepted solution]

I would suggest:

- Make a table of month names and short forms

- Use a case insensitive find and replace and it will match the month part of the string

Quick sample attached

[JamesC]

As long as it's always going to be in that text format, the regex tool can solve it - just be careful of any false positives, such as "Maybe April?" in your data

[ferha_jafri]

Thanks , I have created 2 columns as Months and Short Mon in my data set now I want to implement the condition in already existing formula, so Ho can I compare 2 field with case insensitive comparison.