Hello All,
I was wondering if anyone could offer some pointers on extracting data from
a text file that is formated.
I need to extract the data that is under the column headers. I have
attached a sample of the printed report. The real report repeats the same
format over and over again until completion.
I would like to extract the data and place it in an excel spreadsheet.
Your help and suggestions would be greatly appreciated.
Thanks All,
Will
19:36:36 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
PAGE: 1
FUNCTION: ARTB xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
DATE: 12/17/2003
FROM: 000000 THRU: 999999 SORTED: CUSTOMER CLASS
1
===================================================================================================================================
CUSTOMER GROUP: CUSTOMER CLASS 1 =
===================================================================================================================================
CUS ID CUSTOMER NAME CYCLE CUSTOMER TYPE ACCT CONTACT
PHONE CREDIT LIMIT
------ ------------------------------ ----- --------------- --------------------
--------------- --------------
003678 xxxxxxxxxxxxxxxxxxxxxxxxxxxx 1 OPEN ITEM
0.00
INV NO TYP INV DATE CURRENT 1-30 31-60 61-90 OVER
90 ON HOLD UNAP CASH* TOTAL A/R
------ --- -------- ----------- ----------- ----------- -----------
----------- ----------- ----------- -----------
054616 I 121703 603.73
603.73
CUSTOMER TOTALS ----------- ----------- ----------- -----------
----------- ----------- ----------- -----------
603.73
603.73
-----------------------------------------------------------------------------------------------------------------------------------
CUS ID CUSTOMER NAME CYCLE CUSTOMER TYPE ACCT CONTACT
PHONE CREDIT LIMIT
------ ------------------------------ ----- --------------- --------------------
--------------- --------------
003662 xxxxxxxxxxxxxxxxxxxxxxxxxxxxx 1 OPEN ITEM
0.00
INV NO TYP INV DATE CURRENT 1-30 31-60 61-90 OVER
90 ON HOLD UNAP CASH* TOTAL A/R
------ --- -------- ----------- ----------- ----------- -----------
----------- ----------- ----------- -----------
054601 I 121603 4,900.00
4,900.00
CUSTOMER TOTALS ----------- ----------- ----------- -----------
----------- ----------- ----------- -----------
4,900.00
4,900.00
-----------------------------------------------------------------------------------------------------------------------------------
===================================================================================================================================
GROUP TOTALS ----------- ----------- ----------- -----------
----------- ----------- ----------- -----------
5,503.73
5,503.73
PERCENTAGE OF TOTAL 100.00
100.00
=========== =========== =========== ===========
=========== =========== =========== ===========
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>
