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

abrouwer
8 - Asteroid

@CatheyH Regex101.com is a great resource

OllieClarke
13 - Pulsar
13 - Pulsar

I went for as dynamic an approach as I could, although it might be over-engineered.

Spoiler
I used a rounded location of strings to try and dynamically assign the headers and data - unfortunately because of the blank column I had to have a hardcoded max amount of spaces (20) to turn into pipes.
Challenge 262.PNG
"Applied Amount in transaction currency" really messed me around
SWalker
7 - Meteor

Tried to complete without Regex. Cheated a little by pulling the column names from the solution for the dynamic rename. 

Spoiler
Challenge_262_Teaser.png
RichoBsJ
10 - Fireball

Hi! Here my solution 🙂

 

Spoiler
challenge262.jpg
Kenda
15 - Aurora
15 - Aurora
Spoiler
Kenda_0-1617738965015.png

 

Toons
12 - Quasar

My solution :

 

Spoiler
Toons_0-1617741571331.png

 

JasonHu
8 - Asteroid
Spoiler
workflow.png

Here is my solution!

balajilolla
8 - Asteroid
Spoiler
Solution Attached

balajilolla_0-1617766784918.png

 

kelvinlaw
8 - Asteroid

Here is my solution:

Spoiler
kelvinlaw_0-1617776228874.pngkelvinlaw_1-1617776312763.png
kelvinlaw_2-1617776347607.png

 

Maskell_Rascal
13 - Pulsar

Messy solution! I tried to make it dynamic, but ultimately this workflow would need to be adjusted depending on the additional variables. Interesting challenge though.