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 #188: Difficult, but not im-parse-able

hlombemalandela
7 - Meteor

Here is my solution

sknman92
8 - Asteroid

regex magic!

JRBeaudry
8 - Asteroid

Probably a better way to go ! I'll be looking at the solution after this ! 😁

 

Spoiler
ok, my regex is rusty !!  🤣

 

JRBeaudry
8 - Asteroid

oups

 

Spoiler
after visiting the solution, I see that I forget to change the negatif number to the good fomat 😱 lol

sorry my bad !
Swathi
9 - Comet

PFA for solution

asusko
6 - Meteoroid

See attached solution.

snbandi
8 - Asteroid

Still learning new tools, Regex. Took a long winded route to split into Header set and Details set. For the header set, I noticed below -

 

| 15 |123-43-92508|#### | 15 | | |1|4|9|1|6|8|1|8|2|9|1|9| | |1|4|9|1|6|8|1|5|8|2|0 | |

 

VAT ID 123-43-92508 has 15 transactions but the line details under it has only 9 rows. Maybe I need to extract the Total amount from the header of    |1|4|9|1|6|8|1|8|2|9|1|9| and match to the summary total of rows appearing below.

 

Overall a great learning start for my journey towards Advanced certification.

olga_strubbe
11 - Bolide

I admit this was quite a challenge to untangle :)  Thank you, @AYXAcademy

I followed a similar approach as in the solution provided. 

Capture.PNG

aaroncpotts
7 - Meteor

Learned some things about DateTime functions and got multi-field calculation practice

 

Spoiler
Challenge_188_Solution.png

mgaronson
11 - Bolide
Spoiler
Challenge 188 Workflow Pic.png

 Regex for the win! Prefer dates to be date fields, so solution isn't an exact match.