Challenge #37: Parsing a Raw XML File

[Carolyn]

---

@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

[Carolyn]

Solved

Spoiler

 

[Rob-Silk]

My solution below:

Spoiler

[Tofel]

Spoiler

[fluteman]

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]

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

My solution is attached. 

[Sebastian_Chaieb2]

XML parsing still hides a lot of unknown to me

Spoiler

 

[asultanov]

Spoiler

[snbandi]

My solution

[Raj]

Solved!