Challenge #13: HTML Table Parsing

[moritzsturm]

Solution attached.

[Laszlo_D]

[KatieA]

Solution attached!

[Trumble_dup_334]

Done it, but not sure how to show Nulls as [Null] rather than <Null>. Summarize tool maybe?

[wwatson]

My solution

[JonathanW]

[RWvanLeeuwen]

Again my solution.

Spoiler

I thought I had submitted my solution, but when I ran the workflows from the index (next) this one was still empty somehow
Download this workflow created by @ Hannah_Lissama, @ Alekh, and @ mceleavey.
or try this app to download your unsolved challenges. (Created by: @ LordNeilLord)

[andypick]

solution attached

Spoiler

[SueDonim]

I admit to have learned much from @markp201 and a similar workflow he made for parsing HTML, though it did require some adaptation.  With that in place, it was all pretty straight-forward

Spoiler

Process:
- Remove line breaks and white space
- Remove all tags other than \td and \tr
- Clean-up
- Split row data into rows
- Split column data into columns
- Clean-up
- Trim whitespace
- Remove pipes
- Remove non-relevant records
- Convert empty cells to null