Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #4: Date Parsing

Highlighted
Alteryx Partner

Hereby the solution.

Highlighted
7 - Meteor

Hi all,

 

I think it can be simplified and I went overboard with select, but it's fine, it's fine

Highlighted
Alteryx Partner
Spoiler
Blake_0-1581441104862.png
Would have liked to do it all in regex but didn't have the patience...
Highlighted
8 - Asteroid
Spoiler
tiffanyshaw_0-1581527053647.png

 

Highlighted
Alteryx
Alteryx

Hi there, here is my solution, took me a while to figure out the and in the regex to get the data into one column only but found it, also I'd like to recommend this page that makes super easy to review and try regex https://regex101.com/. 

 

 

 

 

Spoiler
([a-zA-Z]{3}\s[\d]{2}.\s[\d]{4}|[\d]{2}-[a-zA-Z]{3}-[\d]{4}|[\d]{2}-[a-zA-Z]{3}-[\d]{2}\B|[a-zA-z]{3}\s\d\s[\d]{4}\B|[\d]{2}-[a-zA-Z]{4}-[\d]{4}|[\d]{1}-[a-zA-Z]{3}-[\d]{2})

Regex.png

 

 

Highlighted
7 - Meteor

My solution

Highlighted
8 - Asteroid

Thanks.

Highlighted
6 - Meteoroid

Solved

Highlighted
6 - Meteoroid

tricky

Highlighted
8 - Asteroid