delimited database perl count
Posted on 2005-05-12
Here is what I have:
text delimited data base (sample):
00017|JC|68.192.000.000|Wed May 11 13:30:35 2005
00013|SD|68.196.000.000|Wed May 11 13:31:49 2005
The first data piece in each row (i.e., column A, 00017 & 00013) are various tags that I want to count and display the results, as a summary. The data base may be 400 rows, and about 40 variations of column a.
I would like results to say something like:
00017 total count 35
00013 total count 19
Not sure where to begin.....