Challenge #188: Difficult, but not im-parse-able

[hlombemalandela]

Here is my solution

[sknman92]

regex magic!

[JRBeaudry]

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

Spoiler

ok, my regex is rusty !!  🤣

[JRBeaudry]

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]

PFA for solution

[asusko]

See attached solution.

[snbandi]

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]

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

I followed a similar approach as in the solution provided. 

[aaroncpotts]

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

Spoiler

 

[mgaronson]

Spoiler

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