Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHi Team,
This was my first time solving a difficult/advanced problem and first time using the regex method to parse data. Had a lot of fun learning different methods. I used a total of 5 reg ex tools to extract the dates although I know see it can be done in 4. Then I used a union tool to merge all the extracted data. Then finally used formula tool to get the dates in a single column in the required format and at the end uses datetime parse tool to change the format of the date. Looking forward to solving more such challenges.
Always love practice with the RegEx tool
learned alot from this one