Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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

catherineduffy
8 - Asteroid
Spoiler
Good RegEx practice for me - text input and find/replace is to replace shortened month names to full
challenge_4.jpg
pasccout
8 - Asteroid

Here is my solution

jmp
7 - Meteor

My solution is attached.

TomE
7 - Meteor

Had to dust of my (limited!) regex knowledge

datamonkey
8 - Asteroid

I'd rather it didn't generate so many warnings, but it gives the required output!

Hary
7 - Meteor

Done!

Thank you for great challenge for Regex tool.

jbranaum
8 - Asteroid

Here is my solution.

 

Definitely not as elegant as a single reg ex parse operation but it did get the job done.  Essentially I just broke out my reg ex into multiple tools to account for each date scenario.  It helped me keep track of what was happening easier but is likely not as future proof, if the data changes.

 

 

 

 

Patrick007
6 - Meteoroid

My solution for challenge #4.

TonyM
Alteryx Alumni (Retired)

regex to parse different formats and formula tool to move to a single column

ewelch531
7 - Meteor

Ok be gentle with me...I really struggled on this one because I am just learning REGEX