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 #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