Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

abrouwer
8 - Asteroid

@CatheyH Regex101.com is a great resource

OllieClarke
15 - Aurora
15 - Aurora

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
11 - Bolide

Hi! Here my solution 🙂

 

Spoiler
challenge262.jpg
Kenda
16 - Nebula
16 - Nebula
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

 

kelvin_law1
9 - Comet

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.