Challenge #40: Parsing a HTML File

[cgoodman3]

Spoiler

I found this post really helpful as I usually do lots of text to columns to parse out the tags, but by searching for the last instance of a tag you can then get the text after this, which saved some tools.

[RWvanLeeuwen]

I think I solved it although I am unsure about a few records... It seems I am missing a few physicians but I'll be needing an expert opinion on where these records went.

My workflow:

Spoiler

[joemkcarr]

Enjoyed this one

[Hannah_Lissaman]

Another challenge where RegEx does a lot of heavy lifting! Here's my solution:

[Greg_Murray]

Solution attached

[KaleyVolk1]

I just started using this application (love it btw) and here is my solution!

[KaleyVolk1]

I just started using this application (love it btw) and here is my solution!

[Johnny_Analytics]

Spoiler

[smoskowitz]

It's crude and not elegant -- but it gets the job done.