That means o/p should be sorted on 1st field and for every duplicate for that key, a filed should be added which contains the number of records that has the same key in the entire file.
Hi,
Thanks for your reply.It is working fine for the input given above.However When the input is having more than 10 duplicate records,I am getting only the last digit of the count.For exaple if there are 13 records with the duplicate key,I am getting only 3.Is there any solution to get 13.
Is there anyway,so that output should have the records in the order as input that means without sorting and the last column is the sum of duplicates.please let me know.
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
EJPREDDY,
I gave you what you asked for. You showed a 1-digit count in your output so that's what I gave you by using EDIT=(T). As Krishy pointed out you can use EDIT=(TT) to get a 2-digit count (or EDIT=(TTT) to get a 3-digit count, etc). In the future, please be more careful to ask for what you actually want.