Challenge #13: HTML Table Parsing

[Tgigs]

My solution attached.

Step 1: Used regex tool to tokenize description column to rows using expression <td>([A-Za-z0-9\-{}<>\.\s]*?)<\/td>

Step 2: This results in 29 rows, first one is blank so filtered out the blank row

Step 3: Then added record ID column and split dataset into 2 based on even/odd record ID since name/value is every other

Step 4: Joined together the 2 datasets using join multiple tool based on record position

Step 5: Used select tool to clean up the dataset and put in format consistent with the provided solution

Not the most dynamic solution but got the job done.

[danielhoge]

Spoiler

[caltang]

Done!

Spoiler

[Computernerd]

Funny, I thought for sure I was doing this the hard way, but the solution was very similar.

[JClinton]

Spoiler

SPOILER 

[JXEC]

RegEx is always tricky to work with. But this should do it.

[JBLove]

Solution attached.

[afnfyz]

Regex to the rescue!

Spoiler

[RasmusFormo]

My solution :)

[TopoChico]

hello world!