Regex pattern to extract date format ddMMMyyyy

[MasterOfLogic (David Oku)]

Hi
I have this text “SAVE.INCOMING_418745_16MAR2021(1).ASCII.EPIN.TXT” i want a regex to extract 16MAR2021. Please how do I go about it again.
I wrote this (\d{2}\w{3}\d{4}) but i don’t think its efficient enough

Regards

[ptrobot]

Maybe this would do:

\d{1,2}\p{L}{3,4}\d{4}

[MasterOfLogic (David Oku)]

Thank you . I am trying to achieve something that wouldn’t end up matching a string like “16COT2021” because COT is not a valid month

[Srini84 (Srinivas)]

@MasterOfLogic

Check as below for your reference

Hope this may help you

Thanks

[ptrobot]

What @Srini84 said but remove ^ and $ if you want to match text in the middle. Also you need the option IgnoreCase if the months are not always in upper case.

(([0-9])|([0-2][0-9])|([3][0-1]))(JAN|FEB|MAR|APR|MAY|JUN|JUL|AUG|SEP|OCT|NOV|DEC)\d{4}