Challenge #37: Parsing a Raw XML File

[ncrlelia]

Challenge 037

[RashedDS]

My short solution

Spoiler

[ExploreMore]

Spoiler

I used the XML parsing tool for the first time while trying to follow the suggested instructions in the challenge post! However, the updated solution doesn't use it all. 🤣

The instructions in the challenge post mentioned 26 fields but the solution only showed 25. I left in the "Reference" field to get to 26. I also chose not to format the phone numbers as billions or trillions and left them as a string.

[carmenrapariz]

Spoiler

[Emil_Kos]

Hi,

No xml tool but I didn't read the initial post... 

[carmenrapariz]

Spoiler

[Kevin_VANCAPPEL]

Hello,

  here is my proposal.

  Regards,

  Kévin V.

[DanTh]

Spoiler

Used the "<" and ">" delimiters to split to rows and then reconstruct after Transpose tool.

5/5

[Jotigautam]

Solution

Spoiler

[oly]

Spoiler