Gareth Horton
July 12th, 2002, 02:50 PM
Dan Fine wrote:
> I have a report showing two pages of report per page. Date, Serial Number and Amount
> appear in columns down the left side of the page, then repeat on the right.
>
> The data reads down the left side to the bottom of the page, then continues down the
> right side of the page.
>
> How do I capture this in my template?
Dan,
You will need to do multiple passes.
Create one model to extract the left hand column and one to extract the right.
If you need to work on the data with Monarch, rather than simply exporting, then
export both files to fixed width text files, using the same field order etc, then
open both files in Monarch and create a new model for those input files.
Gareth Horton
Datawatch
> I have a report showing two pages of report per page. Date, Serial Number and Amount
> appear in columns down the left side of the page, then repeat on the right.
>
> The data reads down the left side to the bottom of the page, then continues down the
> right side of the page.
>
> How do I capture this in my template?
Dan,
You will need to do multiple passes.
Create one model to extract the left hand column and one to extract the right.
If you need to work on the data with Monarch, rather than simply exporting, then
export both files to fixed width text files, using the same field order etc, then
open both files in Monarch and create a new model for those input files.
Gareth Horton
Datawatch