Extracting date from file path

Question

Hi all,

I am trying to extract month from file path so that I can do a padleft and get "08","09","10","11" as months in a new column.

Since the file path can change, I want to extract the month from the end(file name format will always be the same).

[C:\Download\2019 Sales\By months\Inputs\1.30.2019 Sales.xlsx|||`2 - Sales]

Can you please suggest the right/dynamic way to do this?

Thank you!

BetterFerret · Accepted Answer

@echuong1 you need a backslash before the period in the regex to escape it's special designation as 'any character'.
@rajputakansha a simpler solution is to use a regex formula  PadLeft(RegEx_Replace([FileName],'^.*?(\d+)\..*$','\1'),2,'0')