Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEANot my finest work but....... I recently learned about the XML Parsing tool so I tried applying it as much as possible here, but the brackets really tripped me up. In the end, I unfortunately still had to resort to doing some manual manipulation. The "official" solution also looks a little clunky so I feel less bad about my solution lol
I am going to have to go back and review how others did this as I think there has to be a better way than how I solved it.
My solution
(The difficult part was to come up with the replace function in the beginning to be able to split to rows later)
I went green this time! Only Regex tools 😄
Primarily to improve RegEx skills
Learnings as beginner: I learnt what unmarked groups are and could put them to use especially with parsing