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 #53: Parsing Report Formatted Data

JP_SDAK
8 - Asteroid

I used regex tokenizer to row, so it will work regardless the number of columns or rows.

Spoiler
JP_SDAK_0-1614576588944.png

Here is a test with an added column and row.  As you can see the Equal Test complains because there is a new field and one more row than expected, so it works as promised.

AndrewS
11 - Bolide

#53

Spoiler
53.PNG
BeginnerMindset
8 - Asteroid

No need for any complicated macros or apps.  I believe this is fully dynamic without them.

 

Spoiler
BeginnerMindset_0-1615472921634.png

 

aiahwieder
8 - Asteroid

Always love a good formatting challenge.

rcarog
8 - Asteroid

Solution attached.

Hub119
8 - Asteroid

Solution attached.  No macros here, but this should still work dynamically I believe.

phottovy
13 - Pulsar
13 - Pulsar

Successfully parsed!

Spoiler
53.PNG
Maskell_Rascal
13 - Pulsar

Here is my solution!

 

Spoiler
Maskell_Rascal_0-1620937799171.png

 

Cheers!

Phil

byagelski
8 - Asteroid

my solution...

Jonny
11 - Bolide

another one done. good challenge with simple Macro input.