Challenge #4: Date Parsing

[spencerhong]

Advanced level - check. Pretty challenging

[CandiceDB]

My solution:

Spoiler

[RashedDS]

I liked practicing Regular Expression

My solution..

Update: 

I improved my solution, reduced the number of tools in the canvas from 9 to 5

[Maskell_Rascal]

Decided to try to write one massive formula to handle the date conversion after the RegEx parsing. Fun challenge!

Spoiler

DateTimeParse(IIF(IsEmpty([RegExOut1]),trim(left(REGEX_Replace([RegExOut2], '[[:alpha:]]', ''),3))+'-'+Trim(REGEX_Replace([RegExOut2], '([^][a-z])', ''))+'-'+Trim(right(REGEX_Replace([RegExOut2], '[[:alpha:]]', ''),4)),[RegExOut1]),'%d-%b-%Y')​

[AdrianMa]

My solution.

Spoiler

[Lili1]

my soultion!

[bandhakaviarun]

Here is my solution.

[SWalker]

Spoiler

 

[Steph_Maddrell]

Spoiler

[ENix]

Spoiler

First one tool solution! Probably could rationalise expression further using or (|) in the regex.