Text file generated in report format, would like to extract 'pieces' of data from the report and write to a table in Access. Example of 1 page from report with header on each page (sorry but the text is wrapping when it is posted here): DATE 02/25/03 ABC HATTANOOGA PAGE 1 TIME 10:38AM LIST OF COLLECTION ACCOUNTS SELECTED RESIDENTIAL CALL LIST 2/25/2003 CUSTOMER # CUST NAME METER # COLLECT DT DUE ON DT T/O DT COLLECTION AMT BUD AMT TIMES DEL BUD INS CURRENT 30 DAY 60 DAY 90 DAY LPAY ARBAL 310-0013.001 EVELYN T BARTERS 119759 02/25/2003 02/13/2003 02/26/2003 303.59 1 ELECTRIC 290.69 12.90 303.59 3342 SOUTH ADINS RD APT Q 423-634-1154 99 RESIDENTIAL # bills: 4 # ntcs: 4 # colls: 0 # chks: 0 Crd Rating: U ------------------------------------------------------------------------------------------------------------------------------------ 340-0015.001 TIMOTHY C BUMGARD 120037 02/25/2003 02/13/2003 02/26/2003 62.83 ELECTRIC 59.89 2.94 62.83 3341 OUT LAKE RD APT CCC 423-825-0215 99 RESIDENTIAL # bills: 3 # ntcs: 3 # colls: 0 # chks: 0 Crd Rating: U ------------------------------------------------------------------------------------------------------------------------------------ I need to pick up the phone number, name and credit rating fields while ignoring headers and other lines of text. They are always same number of spaces from left but have 4-5 lines of data between each record. Report may be 5 pages or 100. Header consists of 4 lines, footer to each record are the dashes, record itself is the 4-5 lines. Expected data extraction results from above example data should be in comma-delimited format like this: EVELYN T BARTERS,423-634-1154,U TIMOTHY C BUMGARD,423-825-0215,U Can provide example file if needed for quote.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done as described. 2) Complete ownership and distribution copyrights to all work purchased.
## Platform
Windows OS 2000/XP using Access XP