Want to get involved? We're always looking for ideas and content for Weekly Challenges.
Posting my 1st Weekly Challenge.
Used FindReplace and Regex. Regex took some trial and error. Neither method as efficient as the given solution.
Ended up doing two solutions for this one. The first (in the v1 container) using a text to column. For my final solution I decided to practice my regex skills.
Here's my solution. I removed the commas and quotes with regex and the converted the date.
Didnt add pic the first time I commented. Here is pic of solution.
This was my first completed challenge!
Here is my solution:
Please find the attached workflow.
See solution attached :)