Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAMy solution
Overwhelmed by the messy data. It helped to go through some solutions, and as well as export the data into an excel. Got a solution at the end.
I cheated/copied the well-structured part from the browse tool.
Exported the input data into excel, and observed the structure of the data, and figured out the logic of using Regex match ^\(\d\/\d\d\/\d\d\) to get the date, and the line above with data. Actually ^\(.*\) was able to do the job.
Familiarity with the structure of data will definitely help with such a problem.
Here is my solution