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 #262: With-invoice

nlensing001
7 - Meteor

My solution

AngelosPachis
16 - Nebula

My solution for challenge #262. 

 

Spoiler
AngelosPachis_0-1618158496358.png

 

ulaimins
6 - Meteoroid
Spoiler
Alteryx Challange #262.JPG
JP_SDAK
8 - Asteroid

The hardest part was finding the original post to reply to!  😁  I did this dynamically for headers, but it still seems a little long.  I parsed headers and data separately, maybe I could have combined?

Spoiler
JP_SDAK_0-1618243863439.png

 

randreag
11 - Bolide

here my solution

Ladarthure
14 - Magnetar
14 - Magnetar

Maybe not the easiest and straight forward way to do the job but went with a dynamic regex solution

lewanark
8 - Asteroid

oversimplified solution  without dynamically found headers and/or length of the field, but still fun 🙂

Spoiler
lewanark_0-1618326997920.png

 

phottovy
13 - Pulsar
13 - Pulsar

Props to @PhilipMannering@BeginnerMindset@Luke_C@Harshal_S@TonyA@CatheyH, @OllieClarke, @Maskell_Rascal, @JP_SDAK, @Ladarthure  (apologies to anyone I missed) for attempting to solve this challenge with a dynamic solution! 

 

I enjoyed dynamically calculating a ReGex expression to split based on the number of dashes but could never quite figure out how to use the expression in the RegEx tool. Here is a different approach with an iterative macro.

dsmdavid
11 - Bolide

Kind of dynamic, depending how much invoices change...

Spoiler
dsmdavid_0-1618589215126.png
dsmdavid_1-1618589334819.png

 

 

byagelski
8 - Asteroid

Parstar - I love it.