This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
That was hard - I managed to use three separate regex tools to match all the dates, then joined them based on most specific match to least specific
Shout out to @markp201 for his RegEx solution for which I had to learn RegEx first in order to understand the meaning of it
Solution Attached. Regex makes this a lot easier!
Fun! With only four date formats, it seemed simpler to just filter and parse each format separately than to convert them.
Learned a lot about regular expressions:
Here's my solution!
Hi All - here's my solution. It somewhat lacks the same level of detail as the solution but works quite nicely. This one I loved doing as very typical of things I've had to clean up at work.
Used Regular Expression tool and DateTime Tool to extract dates and convert from strings.