Challenge #116: A Symphony of Parsing Tools!

[RichoBsJ]

Hi! Here my solution :)

[hanykowska]

now that was A LOT of RegEx for me! I'm also getting slightly different results - it seems I have a wider date range in my downloaded data

[cplewis90]

My solution! I was not matching back to the output as there were some cases it didn't match the input file. Program ID = 13642 is an example. The Piece IDs don't match fully to the XML. @ChristineB 

Spoiler

I had to do a lot of testing with the XML parse tools and continually copy and paste to look at the fields I wanted tot parse and ensure I was getting the correct results. Very tough challenge!

[Kenda]

Spoiler

Looks like I need to get on this XML Parsing train

[TimothyManning]

Spoiler

I ignorantly didn't really understand the structure of xml and what the xml parse was really doing, so I only used one, and then tried to parse out the rest using regex and multirow formulas. I did think it must be easier (!) and so after finishing, I looked at the spoilers and used several xml parse tools as in the solution.

[piotrzawistowski]

My version.

[RolandSchubert]

Good practice for XML parsing tool ... but I think, I'll never really like it.

Spoiler

[Jonathan-Sherman]

Challenge 116 is done!

Spoiler

[OllieClarke]

Not sure mine is the best way, but it works...

Spoiler

[PhilipMannering]

@OllieClarke I think this is one of those times you need to put down the regex tool and try XML parsing. It's your Maslow's Hammer.