I'm trying to use the print report to import a multi line bank statement. I've attached a redacted example of the source statement.
I can almost manage to import the first column using mutli-line, ending on a defined field, however the third transaction with three lines appears as a single line and the fourth line is merged into line 3. I believe this is because of how I set the traps, though I can't see any other way to approach this. See attached "MULTI LINE - FIRST COLUMN ONLY.jpm"
When I add the payment amount (200.00 in these examples), the multi line just cuts off at the first line. I've tried adding this in the base layer, or as it's own layer, but get the same result. See attached "MULTI LINE - INC PAYMENT.jpm"
Source Data (as attached in the text file, the pipes are all in the same column)
I'm aiming to achieve the below
EXAMPLE LINE 1 INFORMATION|TT|200.00||11 MAY 22|||
EXAMPLE LINE 2|TT|200.00||11 MAY 22|||
EXAMPLE LIN E 3 INFO SPLIT OVER 3 LINES|TTT|200.00||11 MAY 22|||
EX 4 SINGLE LINE|TTT|200.00||11 MAY 22|||
Is anyone able to advise?
Last seen: 2 months 3 days ago
Joined: 02/15/2017 - 11:28