Challenge #40: Parsing a HTML File

[DanTh]

Spoiler

No RegEx for me, but split to rows based on a "<" delimiter, identified where the Doctors were and then found each unique tag which indicated the header/ data pairs.

5/5

@Erin - Good spot and I completely missed that in my solution! Some of the Doctors don't have a registered address (your first few nulls), but then the ones past 1,000 have a difference in the HTML so that the tag isn't </span><br/> but </span><br /> (with a space after "br"), see 1,068: <h4><span>206 W. County Line Road, Suite 210</span><br />Denver</h4>.

Adding a second Replace formula with this case should do the trick! 

[Erin]

Thanks @DanTh ! I'll give that a try! 

[ARussell34]

I know I made this way way longer than it needs to be, but I tried to keep pushing without checking any other posts and realized that I could have used the xtml parsing tool. Otherwise, I was able to get the right output, just with many many filter tools involved.

[Ollie_G_M]

Here is my solution 🙂 

Spoiler

[JyotiVG]

My solution .. 🙂

Spoiler

[JesusER]

My solution to this challenge

Spoiler

[MichelleL]

HTML tags  . . . who knew they existed 😉  REGEX was my friend . . .

[BenFr]

Another one where the many tools get used!

Spoiler

[leozhang2work]

Spoiler

A bit practice with RegEx. Final answer has some difference with the answer, as I kept all practice rather than the first.

There is also an issue with 649

[OliverHosking]

Hello,

here is my solution