Weekly Challenges

DanTh · ‎08-26-2021

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!

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 - 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 · ‎08-26-2021

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

ARussell34 · ‎08-26-2021

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.