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

dillon_bok
8 - Asteroid
Spoiler
Week 4.PNG

needed a little help with regex but figured it out after that

CaraI
Alteryx
Alteryx

Rocked my first Advanced challenge ... might not be pretty, but got the job done.

jsdeter
8 - Asteroid

Solution to Challenge

JDelgado
8 - Asteroid

I gotta say - this parsing text to find a date somewhere within the string, allowing for variation in date formats, has me stumped...

 

Without giving away too much, can someone give me a hint on how they did the parsing? (I don't want to look at anyone's full solution)...

 

:-D

 

JohnD

ivoller
12 - Quasar

@JDelgadosee Regex Tool help

JDelgado
8 - Asteroid

That figures... I was never very good at writing regex expressions... thanks!

JDelgado
8 - Asteroid

Got it.

 

I gotta say, I'm not a fan of regex... that being said, through trial and error I got a solution that works.

 

There is some weirdness going on with the input record that starts with "The best cure for insomnia...

Gauthier_B
8 - Asteroid

Done, glad I could put these newly acquired regex skills to use! Solution below.

 

Spoiler

Challenge4_screen.png

 

LauraScavino
7 - Meteor

 

My first Alteryx Challenge exercise 

 

 

 

 

Spoiler
 Capture96.PNGCapture97.PNG

 

TimothyManning
8 - Asteroid
Spoiler
4. Date Parsing Screenshot.png