We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

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. ; )