Trapping Multiple Rows

Tom S

How can I trap multiple rows into one cell?  I am trying to extract transactions from a bank statement.  Each transaction will have one line with a date, some description, deposits, withdrawals and balance and some transactions may have 1 or 2 additional rows with additional description(s).  I would like to place the total description in one cell.

 

CPorthouse

It looks like you can probably use a two line sample for your detail. Draw your description field on the second line and then use the advanced property to end the field on a blank field value.  It will automatically terminate at the start of the next detail record.

I will use one of our sample files for a demonstration.

In this case I have an employee record that contains an address as well as an Employee #, Office, and Department.  I would select all three lines as my sample data:

Select a new template (in my case "Detail"), and build the trap on the first line.  You do not have to use the first line, but it is the best choice in this case.

You can then select the fields you want to use.  In this example, I would only select the first line for address and then use the advanced properties (or edit field if using classic) to change how I end the field to use "Blank field values: 1":

 

The result:

You can also define the other three fields, if needed.  The final result: