community
cancel
Showing results for 
Search instead for 
Did you mean: 

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #4: Date Parsing

Asteroid

Hi All,

 

This one was tricky,

 

Spoiler
Used Regex and Formulas to extract the date then used Datetime to parse it.

 

Thanks

Mat

Highlighted
 
 
Asteroid

Time to take a break

Spoiler
ZHSOLpng.png
Meteoroid
 
Asteroid

My Solution:

Meteor

My Solution. Regex is an amazing tools

Alteryx Certified Partner
Spoiler
challenge_4_Done_img.png

Alteryx Partner

Getting better at date parsing and a little better at RegEx!!!

 

Spoiler
Process:
- 4 different RegEx statements to pull out each of the 4 types of date formats
- DateTimeParse in first instance as couldn't make it work in DateTime tool
- DateTime tool in other 3 cases
- Merged the 4 temporary date column into one
- Clean-up results

MySolution.PNG
Alteryx Partner
Spoiler
Capture d’écran 2019-10-13 à 23.28.01.png