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

Rob-Silk
8 - Asteroid

An interesting problem - my solution below:

Spoiler
I used the regex parse tool to tokenise the expected rough date format, which could be grouped into two main categories from a regex pattern point-of-view, and output to a new column which could then be converted to date format with the DateTime tool, again one for each of the two main regex patterns.

challenge_4_RS_screencap.PNG
B_SarkadiNagy
6 - Meteoroid
Spoiler
2023-12-05_17h37_29.png
JasonW
6 - Meteoroid
Spoiler
004 Solution2.png

I went with the one tool approach

Shoujain
6 - Meteoroid

Here is my solution

putu_w_erata
8 - Asteroid
Spoiler
 
Capture.JPG

Aratryn
7 - Meteor

Fun working with Regex

asultanov
8 - Asteroid

Good regex challenge.

Medha31
8 - Asteroid

Surely a great practice of regular expressions and string functions. Interesting Challenge!

A good challenge, tried using Regex and some DateTime and Regex functions in Formula tool. 

nSpire
8 - Asteroid
Spoiler
004.png