Joined: 25 Jan 2007 Posts: 39 Location: Charleston SC
I need of your help again. I need to create a summary file. The file attributes are as follows.
Input file:
LRECL: 73
RECFM: FB
The input file appears as follows:
Code:
----+----1----+----2----+----3----+----4----+----5----+---
CB6W001001 F 000001000000000001
CB6W001001 F 000001000001000001
CB6W001001 F 000001000001000000
CB6W001001 F 000001000000000001
CB6W001001 F 000001000001000000
CB6W001001 F 000001000001000000
CB6W001001 F 000001000001000000
CB6W001001 F 000001000001000000
CB6W001001 F 000001000000000001
CB6W001001 F 000001000001000000
----+----1----+----2----+----3----+----4----+----5----+---
I have to total the entries in column 36, 42, 48. For each record there can be multiple total counts. Beginning in column 5 for a length of 6 is the customer number, beginning in column 36 for a length of 6 is the read count, beginning in column 42 for a length of 6 is the update count, and beginning in column 48 for a length of 6 is the add count.
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
Bill,
Do you just want the totals for all of the records, or do you want totals for each customer number? You only show one customer number, but could there be more?