Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEADecided to try to write one massive formula to handle the date conversion after the RegEx parsing. Fun challenge!
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')
My solution.
First one tool solution! Probably could rationalise expression further using or (|) in the regex.