Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAVery exciting challenge. I hadn´t had the chance to do much parsing since I try to do that before I enter data to Alteryx. I don't think the solution is as elegant as it might be but it does the trick. I'm exicted to see how other people managed to attack the problem.
Definitely, I went through the solution proposed by the team and it was clear that using the parsing tool is way easier.
I'm a beginner so my approach is slightly rough on the edges. I used two RegEx tools one for the Values with "-Mon- " format and another for the remaining values. I used the RegEx-parse option in both to get Date,Month and Year columns. I used DataCleansing and Formula toools to format these. After using union for the two sets,I finally used DateTimeFormat to convert it into a standard format.
Loved the official solution,great learning experience.
I tried a few approaches to this but settled on RegEx as the most elegant option for extracting the dates.