Regex a date from the filename

Hi - I have these different formats of file name, how would you best get the date from it:

04 MC report - Apr 2018
04 MC report - Apr 2019
04 MC report - Apr 2020
04 MC report - Apr2015 Revised
04 MC report - Apr2016
05 MC report - May 2017
05 MC report - May 2018

thanks!

Jen

Regex

Date Time

Preparation

Accepted answers

I'm not the best with RegEx but I think this should work -

([A-Z][a-z]+[\s+|\S]\d{4})

Regards,

Ben

All comments

did you notice that the dates are always in the same positions?

substring([filename],15,8)

cheers,

mark

@MarqueeCrew Thanks! I can't guarantee that they will always be in the same position, as this is for 10 years of files, could be missing a space somewhere or have an extra one added.

I'm not the best with RegEx but I think this should work -

([A-Z][a-z]+[\s+|\S]\d{4})

Regards,

Ben

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703