Challenge #13: HTML Table Parsing

[jdunkerley79]

Spoiler

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[DavidThorpe]

My solution:

Spoiler

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[hugolees]

Spoiler

Not sure how scalable my answer is for different formats of HTML, but glad other people have worked it out and I can see it is possible with the XML parsing tool.

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[catherineduffy]

My solution

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[RolandSchubert]

My solution - started using Multi-Row Formula tool and Cross-Tab tool, but switched to Column tool for the first time, really usefull. 

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[smoskowitz]

I am not happy with the way I completed this one. Must of spend about 2 hours on it. I need to figure out a better way. 😞

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[Thableaus]

Challenge #13, done.

Regex makes things as easy as pie.

Spoiler

Cheers,

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[rfergus]

Took me a while to figure out a good RegEx, but it was worth it.

Spoiler

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[Sajeel_Kershi]

completed

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[T_Willins]

As long as the format of the incoming data is consistent, this workflow works.

Spoiler

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.