Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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

PangHC
13 - Pulsar