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

LindaLo
8 - Asteroid

Here is my solution!

tammybrown_tds
8 - Asteroid

My solution.  Thanks, Blake, for the assist from your published solution.

 

Spoiler
Challenge 53.PNG
mpennington
11 - Bolide

Solution attached.  I became obsessed with finding a way to do this with fewer tools using a RegEx and I pulled it off with 4 tools, so I'm adding that to my solution.  When I am stuck at home with the COVID quarantine, I tend to dwell on these things. Solution below shows my original method and the shortened RegEx version.  

 

Spoiler
MP53-1.png

 

aazimh
8 - Asteroid

Nice constraint to have it be dynamic!

atcodedog05
22 - Nova
22 - Nova

On a spree to binge complete weekly challenges

 

Quick and easy

 

Spoiler
This is my solution

atcodedog05_0-1585394242200.png

 

kaianderson
8 - Asteroid

Here's my solution, didn't use a macro.

aheikes
8 - Asteroid
Spoiler
Challenge53.JPG
seinchyiwoo
Alteryx Alumni (Retired)

good practice of macro + regex 🙂

 

Spoiler
seinchyiwoo_0-1587457469086.png

and the macro:

seinchyiwoo_1-1587457533421.png

 

Ben_Jeffreys
8 - Asteroid

My submission

dpencheva
8 - Asteroid

Here is my solution. ; )