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 #37: Parsing a Raw XML File

Carolyn
Comète

@SJKIM wrote:

Does anyone know how to easily compare the answers to see if they are correct?


Hi @SJKIM , 

 

I use the CReW Macro "Expect Equal". I connect the Solution file with my solution and it tells me where I have mismatches. It's very sensitive, so if things are different orders or if you have nulls and the solution has blanks, those will all flag

 

Expect Equal.png

Carolyn
Comète

Solved

 

Révélation
2023-11-10_12-44-35.png

Rob-Silk
Astéroïde

My solution below:

Révélation
challenge_37_RS_screencap.PNG
Tofel
Astéroïde
Révélation
Challenge 37.JPG
fluteman
Astéroïde

I thought this would use the xml tool; but it was a texttocolumns tool - using to rows feature. then we needed to group by Reference ID, Name and increment the name to get the Purchase, Shipment Addresses.

olga_strubbe
Boule de feu

Thank you, @GeneR!  This was a fun one!

My solution is attached. 

2024-01-25_11-29-08.png

Sebastian_Chaieb2
8 - Asteroid
8 - Asteroid

XML parsing still hides a lot of unknown to me

 

Révélation
37.PNG

asultanov
Astéroïde
Révélation
Screenshot 2024-01-30 115938.png
snbandi
Astéroïde

My solution