Challenge #13: HTML Table Parsing

[rachel_lynch]

Spoiler

 

[mithily]

Spoiler

spoiler tried regex but went with replace and text to rows and columns

[rzdodson]

Spoiler

SPOILER

Solution attached. I also went ahead and converted the workflow in to a standard macro should there be future cases where Alteryx users are doing HTML parsing. 

[TanbirJ99]

my solution 

[mattnason1]

Tough one, unfortunately I couldn't figure out the xml parse so read the xml and did it a bit more manually.

[MatteoReddavide]

My solution

Spoiler

[olga_strubbe]

The last record appears to have some strange characters - I am not able to tell why ( .*) in RegEx formula is not able to get rid of them.  I had to write a separate formula to take care of it.  Other that that, a very nice challenge, thank you, @Gene !

[Amy_smart]

Here is my solution. 

[H_a_n_g_C_h_e_n__x3]

A fun challenge

[Swathi]

PFA for solution