Challenge #4: Date Parsing

[mshishido]

reposting the solution since mine was deleted

[Kishori]

Solution for challange#4. Used multiple DateTime function's to understand each date format.

[Carolyn]

Solved! That was fun!

Not quite as pretty as the official solution but I had an easier time doing some "dumb" parsing just to get rid of most of the excess data and then some proper RegEx parsing. I also fell for the trick where things like "Marrying" and "Separator" were included which will cause issues if you're looking for "Mar" or "Sep" but I handled it later

Spoiler

 

[isundari]

ok done.

simply copy-paste regex formula to extract the date, then voila... wow

[AndrewPowell]

Slightly different method than the posted solution, got to love combining regex and Alteryx, so many methods to get to the right answer

Spoiler

 

 regex code on mine was this: (\d{2}-\w+-\d{2,4})|(\d-\w+-\d{2,4})|(\w{3} \d+ \d{2,4})|(\w{3} \d+, \d{2,4}) and since I landed with 4 columns from the groups I used the arrange tool to put them into one column and a filter to remove the nulls

[Hkhawashi81]

Dear Trainer 

To difficult to understand below formula.

if anyone have literature or module easy to understand below formula to find the phrase. 

.*(\d\d-[[:alpha:]][[:alpha:]][[:alpha:]]-\d+).* |
.*(\u\l\l\s\d+,*\s\d\d+).* |
.*(\d+-\u\l\l+-\d\d+).* |
.*(\d-[[:alpha:]][[:alpha:]][[:alpha:]]-\d+).*  

Please find my solution for Challege#4 

Thank You.

Hamdan Khawashi

[MelGibson]

Spoiler

 

[JRBeaudry]

Not shure is the more elegant way to do it 🤣 but it work !

Spoiler

[jake8281]

Hi, I have built 1 long expression from scratch to have all outputs in the same column. I am glad to break it down to pieces and explain briefly . Here is the output 

Spoiler

(\d{2}-\<\w+\>-\d+|\<\u\w+\>\s\d+,*\s\d+|\d+-\<\u+\>-\d+)

[jake8281]

Spoiler

 

have regex built from scratch to output 4 formats in one column 

Spoiler