Search

Close

Start Free Trial

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

An interesting problem - my solution below:

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.

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.

004 Solution2.png

I went with the one tool approach

Here is my solution

Fun working with Regex

Good regex challenge.

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.

Live Weekly Challenge