Challenge #13: HTML Table Parsing

[AcevedoYo]

Not 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

Spoiler

[ENix]

Spoiler

[Emil_Kos]

Definitely not the most elegant solution ever but it definitely works

[TKSnider]

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.

Spoiler

I used a bunch of regex replace statements inside of a formula bar to eliminate anything outside the table, replaced tags with delimiters and then split the remaining data into rows and then columns.  I got to the solution, but I feel it is a VERY clunky way to have done it.

[ARussell34]

Here is my solution!

[Ajjay]

Soln

[MichelleL]

Thank you!

[Elias_Nordlinder]

My solution

Spoiler

(The difficult part was to come up with the replace function in the beginning to be able to split to rows later)

[dhavaldoshi]

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

Spoiler

[ExploreMore]

Spoiler