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

Regex

Date Time

Accepted answers

Hi @Analytics_Pooja

You can use a formula like this

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

Workflow:

Hope this helps : )

All comments

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

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

Formula to extract date from a file name.yxmd

Quick Links

Tags

This months top contributors

AkimasaKajitani 390

michael_weaver 335