Formula to extract date from a file name

[Analytics_Pooja]

Hi Everyone

I am looking for a formula to extract date from a file name 'communication.clientreporting.statements.bds.sr.20190118_095020.xml'

For all the files the date will always be at this location. 

Best

Pooja 

[atcodedog05 · Accepted solution]

Hi @Analytics_Pooja 

You can use a formula like this

REGEX_Replace([Filename], ".*(2\d{7}).*", "$1")

Workflow:

Hope this helps : )

[Analytics_Pooja]

Thank you @atcodedog05 . This works.

Best

Pooja 

[Kamran1991]

If your file name is consistent, you can use this workflow to derive the date