Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #4: Date Parsing

WegmanJordy
7 - Meteor

Hereby the solution.

dark_a
7 - Meteor

Hi all,

 

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

Blake
12 - Quasar
Spoiler
Blake_0-1581441104862.png
Would have liked to do it all in regex but didn't have the patience...
tiffanyshaw
8 - Asteroid
Spoiler
tiffanyshaw_0-1581527053647.png

 

Garabujo7
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

 

 

Sylvana
8 - Asteroid

My solution

dashakir1
8 - Asteroid

Thanks.

samahmed28
6 - Meteoroid

Solved

scullen
6 - Meteoroid

tricky

Pang_Hee_Choy
12 - Quasar