Need some advise and input.
I have a report file, need to read the file and get the information from the report and load it to a database.
which has header, address, date information and data information as rows.
What is the best way to get the report data to table format. Any help is appreciated!
here is sample report .
Code: Select all
AB123 CITY REPORTNAME PAGE: 1
TIME: 15:18:07 FOR 1 DATE: 12/10/04
11111111 ADDRESS1 ADDRESS2 ADDRESS3
PERIOD AMT
------------ ------
ABC 1,662 29.7
BCD 137 2.4
DEF 361 42.2
EFG 62 1.1
------------ ------
TOTAL 5,591 100.0
MRKUP 290 5.1
TOTAL W/O MKP 5,928
TOTAL MRKP 290
TOTAL 6,219
AB123 CITY REPORTNAME PAGE: 2
TIME: 15:18:07 FOR 1 DATE: 12/10/04
11111111 ADDRESS1 ADDRESS2 ADDRESS3
PERIOD AMT
------------ ------
ABC 1,662 29.7
BCD 137 2.4
DEF 361 42.2
EFG 62 1.1
------------ ------
TOTAL 5,591 100.0
MRKUP 290 5.1
TOTAL W/O MKP 5,928
TOTAL MRKP 290
TOTAL 6,219
AB123 CITY REPORTNAME PAGE: 3
TIME: 15:18:07 FOR 1 DATE: 12/10/04
******* ADDRESS1 ADDRESS2 ADDRESS3
PERIOD AMT
------------ ------
ABC 1,662 29.7
BCD 137 2.4
DEF 361 42.2
EFG 62 1.1
------------ ------
TOTAL 5,591 100.0
MRKUP 290 5.1
TOTAL W/O MKP 5,928
TOTAL MRKP 290
TOTAL 6,219
Code: Select all
=================================================================
1111111 CITY PED DATE ADD1 ABC BCD DEF EFG TOTALS
==================================================================
Thanks