Free Trial

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 #151: Meta Parsing

patrick_digan
17 - Castor
17 - Castor
Spoiler
Perhaps I'm over-complicating this, but I went for the dynamic replace. You would have to do a little more work if you wanted to keep the field order the same.
Capture.PNG
pjdit
8 - Asteroid

My solution..

 

Spoiler
Challenge_151_Spoiler.JPG
ggruccio
ACE Emeritus
ACE Emeritus

Figured out a method that is a bit ugly, but I like it and it works!

JoBen
11 - Bolide

Cheers!

Spoiler
Challenge_151.PNG
ipeng
8 - Asteroid

Dynamic data parsing

ponraj
13 - Pulsar

Here is my solution. 

 

Spoiler
Challenge 151 Meta Parsing.PNG
RobertF
7 - Meteor

This one uses a variety of tools.

kat
12 - Quasar
Spoiler
Challenge #151 macro.PNGChallenge #151.PNG
JosephSerpis
17 - Castor
17 - Castor

Challenge Completed 

EW
11 - Bolide

"Each week your boss gives you a new dataset to parse. Each week it comes with a different schema..." sounds like my life!  :)

 

My solution:  

Spoiler

 

I used a recordID in case there were duplicate strings, and a recordID for fields to keep them in the original order.

151EW.PNG