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

cherrington
7 - Meteor

my solution

MartinStraech
8 - Asteroid

Need a lot more practice with Regex, but still enjoyed the challenge with the other parsing formulas.

 

Spoiler
MS - Solution.PNG

TKSnider
8 - Asteroid

Ok, this one was a hard one for me...

 

Spoiler
I'm not a big fan of RegEx to start with and I probably attacked this in the wrong way.  But in the end, I got the right answer, so there is that.

I started by adding a record count, as I thought initially I was going to have to split the data by date time as I parsed out the info and I wanted a way to ensure I didn't duplicate, then decided that if I waterfalled the selections (by letting those selections that I'd already solved for fall out of the process) it would allow me to narrow down the data regex to a better degree.  At the end, I unioned them back together for the final result.  I added a validation piece that allowed me to check my results against those results provided as well.
bjkay30
8 - Asteroid

Catching up with old challenges...  This one was interesting.

 

Spoiler
bjkay30_0-1622123536466.png

 

Mario36
8 - Asteroid

 

Spoiler
This was an interesting one, it helps you prep up with the RegEx tool.

Here's my solved solution. 

 

Nvy
8 - Asteroid

Challenge completed

ARussell34
8 - Asteroid

Here is my solution!

hoadinh
6 - Meteoroid

My solution

taylor_butler
Alteryx Alumni (Retired)

Love an opportunity to use Regex! 

rpratapn
6 - Meteoroid

My Solution