Challenge #40: Parsing a HTML File

[myastarling]

Here's my solution. This also corrects the error on line 649 in the output where the practice is listed under city.

[caltang]

Done!

Spoiler

[Computernerd]

There's actually an error in the Answer Dataset at Row 629.

[lwolfie]

Fun challenge.  I don't use HTML parsing much, so it was great to practice.

[Tgigs]

My solution attached.

Had to look at the solution. Would have helped if I could open the web page but seems to no longer work. Nonetheless, great exercise for parsing HTML data from web pages.

[afnfyz]

Regex really shines when it comes to parsing data. Simplifies the workflow so much.

Spoiler

[DanielG]

Solved

[olga_strubbe]

Please see my solution attached.  This was a tough one.  I leveraged the logic in the solution provided in terms of RegEx Replace functionality. 

Thank you.

[Carolyn]

Solved. I first tried to do this with just RegEx but even after looking at some of the solutions with just RegEx, I didn't quite understand it all. So though I got it to work, I redid it with the Text to Columns + Multi Rows and it ended up a bit ugly, but I got there. I'm happy it's done :) 

Spoiler

 

[TimN]

Hi,

Here is my solution.