We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

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
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.