Date Extraction

So I attached a some data that has a list of file names and at the end of these file names are a date. Can someone help me with extracting the date to it's own column and then making sure the dates are all the same format of mm-dd-YYYY? I've been wearing out my brain on this and I'm sure it's a simple answer and I need a second set of eyes.

date extraction.yxmd

Developer

Accepted answers

Tyro_abc

Tried another option, one step less.

date extraction_aruV2.yxmd

atcodedog05

Hi @COrr

Here is my take on it. Using single formula

DateTimeFormat(
DateTimeParse(
Replace(
REGEX_Replace([File Name], "(.*)_([\d_-]{8,10})$", "$2")
, "_", "-")
,"%m-%d-%y")
,"%m-%d-%Y")

Steps:

1. Extract | 2. Replace _ to - | 3. Date parse | 4. Date Format

Output:

Workflow:

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

date extraction.yxmd

All comments

Tyro_abc

Please check the attached wf. I am sure it can be done with less number of steps, but I got this one quick.

Regards

Arundhuti

date extraction_aru.yxmd

Qiu

@COrr
Hope this is what you need.

date extraction-R1.yxmd

Tyro_abc

Tried another option, one step less.

date extraction_aruV2.yxmd

atcodedog05

Hi @COrr

Here is my take on it. Using single formula

DateTimeFormat(
DateTimeParse(
Replace(
REGEX_Replace([File Name], "(.*)_([\d_-]{8,10})$", "$2")
, "_", "-")
,"%m-%d-%y")
,"%m-%d-%Y")

Steps:

1. Extract | 2. Replace _ to - | 3. Date parse | 4. Date Format

Output:

Workflow:

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

date extraction.yxmd

COrr

dude that is awesome! thank you! I was staring at this and my brain was hitting a brick wall for sure! thanks!

COrr

I absolutely always forget the Tokenize function! thank you!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703