Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #116: A Symphony of Parsing Tools!

RichoBsJ
11 - Bolide

Hi! Here my solution :)

hanykowska
11 - Bolide
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
13 - Pulsar
13 - Pulsar

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!
Challenge 116.PNG
Kenda
16 - Nebula
16 - Nebula
Spoiler
Looks like I need to get on this XML Parsing train

Capture.PNG
TimothyManning
8 - Asteroid
Spoiler
116. Data Parsing.PNG


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
8 - Asteroid

My version.

RolandSchubert
16 - Nebula
16 - Nebula

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

Spoiler
13-08-_2019_17-36-01.png

 

Jonathan-Sherman
15 - Aurora
15 - Aurora

Challenge 116 is done!

 

Spoiler
challenge 116 JMS solution.PNG
OllieClarke
15 - Aurora
15 - Aurora

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

Spoiler
Challenge 116.PNG
PhilipMannering
16 - Nebula
16 - Nebula

@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.