sort on accending order and display the count.
Posted: Mon Sep 14, 2009 3:09 pm
Hello All,
I have a file with the record count of 1000000 in which i need to sort the data on the accending order and then display the record count for a particular condition. Below is the example for better understanding:
Input file:
P AAAA
P AAAA
P AAAA
P BBBB
P BBBB
P CCCC
P DDDD
Output file:
AAAA 3
BBBB 2
CCCC 1
DDDD 1
Thanks
Bodhi
I have a file with the record count of 1000000 in which i need to sort the data on the accending order and then display the record count for a particular condition. Below is the example for better understanding:
Input file:
P AAAA
P AAAA
P AAAA
P BBBB
P BBBB
P CCCC
P DDDD
Output file:
AAAA 3
BBBB 2
CCCC 1
DDDD 1
Thanks
Bodhi