Regex a date from the filename

[jenner85]

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 

[MarqueeCrew]

@jenner85 ,

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

substring([filename],15,8)

 cheers,

 mark

[jenner85]

@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. 

[Ben_H · Accepted solution]

Hi @jenner85,

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

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

Regards,

Ben