Challenge #116: A Symphony of Parsing Tools!

[OllieClarke]

@PhilipMannering 

[TonyA]

 I did it without the XML parser and was happy to see others use that tool so I could understand it better. I did notice that the XML Parser solutions I looked used a lot fewer tools but took a minute or two to run while mine takes 2.2 seconds. Then again mine took a couple of hours to build.

[T_Willins]

I tried both RegEx and XML Parse tools and neither matched the given solution.  Looked at the downloaded data and there are discrepancies there, so I think the starting data is different now.  Kept the RegEx workflow as it is much faster.

Spoiler

[KMiller]

Solution attached.

Spoiler

[RWvanLeeuwen]

A large amount of effort went into parse this data, but when it's done it is very rewarding.

Spoiler

[nini]

happy to learn about XML parse tool, thanks!

[JamesCameron]

Here's my Effort. Doesn't quite match the provided answer, but as others have commented, it looks like the source data has changed slightly

Spoiler

[mbogusz]

Spoiler