I have a PDF file that I need to extract dta from. The detail selection is easy, as it is formatted well, but there are several other "detail" records I need that are in a completely different format on the report. I could easilty capture them ad append templates but that is not necessarily the relation ship of the data, they are essentially records of the same type as the detail, just happen to be embedded in the report differently. I am wondering if there is any way to do this without having to run a separate model against the sheet for each additional line detail record.
Here is the layout of the file...
9100 Visa - 9,429.70
9105 Mastercard - 3,460.22
9110 American Express - 6,868.68
9130 POS - Visa - 1,167.59
9135 POS - Mastercard - 453.93
9161 Direct Bill / City Ledger - 257.03
Payment Total - 68,827.11
Transaction Total Today - 29,239.66
Grand Total 80,748.22
AR Ledger Payments 46,372.09
Deposit Ledger Activity 0.00
Balance Carried Forward 127,120.31
Accruals Today 0.00
Guest Ledger Balance 127,120.31
Balance Yesterday 109,987.88
Payments - 22,455.02
Deposits Transfered at Check-In 0.00
Balance Today 127,120.31
Balance Yesterday 375,170.00
Charges and Transfers 257.03
Payments - 46,372.09
Balance Today 329,054.94
I can easily capture the records in the first rows with the gl codes listed, but I want to catch the AR Ledger payments amounts, and Guest Ledger amounts, etc, as detail records.
Any help would be appreciated.
I have every version of Monarch and Datapump since 6, so my solution shouldn't be limited....