We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #262: With-invoice

nlensing001
7 - Meteor

My solution

AngelosPachis
15 - Aurora

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

 

aruiz-itp
11 - Bolide

here my solution

Ladarthure
13 - Pulsar
13 - Pulsar

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
12 - Quasar

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.