Challenge #13: HTML Table Parsing

[patrick_digan]

Spoiler

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

[Natasha]

Looking at other's solutions now, I guess I really wanted to use HTML Parse tool...

Spoiler

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

[MaxGiegerich]

Strange this one is 'Advanced'... Seemed fairly straight forward but did involve some reasonably fiddly string calculations.

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

[JoshKushner]

You won't  believe how long I struggled with the Regex parser only to use the text to columns for the solution

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

[SeanAdams]

don't give up on Regex @JoshKushner - try this one again, but use http://regex101.com and you'll work through this one really easily.

[dsmdavid]

Next time will try to use the make columns tool

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

[samN]

Im glad regex still has not let me down. Could this have been done a better way? eh i wont worry about it. 

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

[Waynemk]

feels like its inelegant, but it works

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

[ggruccio]

This one was a struggle!  Solution a bit ugly, but it works.

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

[LandonG]

Spoiler

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