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

mat_budden
8 - Asteroid

Hi All,

 

This one was tricky,

 

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

 

Thanks

Mat

kmbutterfield
7 - Meteor
 
AbbieRoss-Carter
8 - Asteroid
 
ZenonH
8 - Asteroid

Time to take a break

Spoiler
ZHSOLpng.png
Peter-H
6 - Meteoroid
 
nini
8 - Asteroid

My Solution:

EdwinYakop
7 - Meteor

My Solution. Regex is an amazing tools

Sebenius
8 - Asteroid
Spoiler
challenge_4_Done_img.png

SueDonim
8 - Asteroid

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
AMansour
11 - Bolide
Spoiler
Capture d’écran 2019-10-13 à 23.28.01.png