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

Sashikumar
8 - Asteroid

My Solution  😎

Spoiler
ch262.PNG
Morgan_Thomas
8 - Asteroid

Attached is my solution. This was fun and its always good to practice some regex!

Spoiler
Challenge 262 screenshot.png
rcarog
8 - Asteroid

Solution attached.

 

Spoiler
rcarog_0-1617639095628.png

 

Spalders
8 - Asteroid
Spoiler
Spalders_0-1617642763468.png

 

inspired by @PhilipMannering 

echuong1
Alteryx Alumni (Retired)

It might make more sense to append the receipt information to each record 🙂 

 

Spoiler
echuong1_0-1617645889256.png

 

Harshal_S
5 - Atom

Spent a lot of time on getting the column names dynamically but ended up hardcoding it. Excited to see submissions from others.

 

Spoiler
Harshal_S_0-1617650437485.png

 

cchandler21
Alteryx
Alteryx

here is my solution!

jackf
7 - Meteor

Attached is my solution

mike_w
8 - Asteroid

wow, some serious Regex going on here! 

Spoiler
mike_w_0-1617661720234.png

 

TonyA
Alteryx
Alteryx

This one was fun. Hard to make it truly dynamic, but I tried to make the hard-coded parts relatively simple to change. Also tried to keep the REGEX to a minimum just how much I could do without it. Managed to limit it to two simple REGEXReplace formulas.

Spoiler
Figuring out the field labels was the hardest part, had to look at all three lines character by character to align them properly. 

2021-04-05_17-20-44.png