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

[AYXAcademy]

A solution to last week's challenge can be found here!

This week's Challenge come to us from @T_Willins! 

 
Your tax group has advised you that the information they need is available only in a .TXT report. To properly import the data into a subsequent system, they need the data filtered and in a specified format.

First, match the ID no. from the totals rows to the corresponding detail lines. Then filter to only detail rows with a tax codes of P1 or P9. Format, sort order and field names on the output file must match the given output for the file to load correctly.

 

[OllieClarke]

I'm so thankful for RegEx

Spoiler

[NicoleJohnson]

I got 99 problems and at least 98 of them are RegEx. 🙂

Spoiler

Cheers!

NJ

[PhilipMannering]

Copied Ollie,

Spoiler

Workflow

[patrick_digan]

I'm on a roll over complicating these last few challenges.

Spoiler

[justindavis]

Start file contains a few rogue tools, at least when I downloaded it... Was that intended?

Spoiler

[Blake]

This was a fun one! 

Spoiler

[paulfound]

may need to up my Regex game...

Spoiler

Edited: better image of workflow. 🙂  

[hbraunius]

My solution attached.

[LiD]

Spoiler