Challenge #4: Date Parsing

[Milanz]

Done 😉

Spoiler

[jarrod]

not quite as bad when you get into it, but definitely 10x easier in python using the dateutil package

Spoiler

 #SnakingMyWayThruChallenges

[jimmygatliff]

Spoiler

Originally had 7 different RegEx tools, until I realized I could use the + and * symbols. 

Added a join tool to check results and make sure the dates matched to the solution output.

[MRod]

I'm learning more RegEx and appreciate the solution. In my solution, I created all possible values for Month, Date, and Year and then created the new date.

Spoiler

[jarrod]

just had a quick edit to my previous response - Python can be cleaned up further with the following Formula:

Spoiler

from ayx import Alteryx
import dateutil.parser as dparser
import numpy as np


df = Alteryx.read('#1')

df['datetime'] = df['Field_1'].apply(lambda row: 
                                     dparser.parse(row,fuzzy=True))
    
Alteryx.write(df,1)

The "apply(lambda)" allows for a row by row calculation and is quite fast.  

[praveenskumar]

The tools I used in this solution are

1. RegEx
2. Formula

[DMContente]

My solution, from a while ago

[jiuh_park]

Tried using various tools to practice 🙂

[AcevedoYo]

First time using RegEx! It wasn't as scary as I thought it would be to pick up although it's very obvious I still have a lot to learn

Spoiler

[deviseetharaman]

Spoiler

Not sure why I am not able to parse Nov 16 1900 with datetimeparse function.