Date Extraction

[COrr]

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.

[Tyro_abc]

Hi

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

[Qiu]

@COrr 
Hope this is what you need.

[Tyro_abc · Accepted solution]

Tried another option, one step less.

[atcodedog05 · Accepted solution]

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 😀👍

[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!

[atcodedog05]

Happy to help 🙂 @COrr 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any issues 🙂