Counting phone numbers

[YOUNGCODGER]

Hello,

I have an extremely large text file with over 1 million lines. The data is in fixed positions and relates to phone calls. I need to find how many times each number was called. 'Cut -c' and sort and sort will give me the list of numbers but how do I get a total for each number?

Many thanks,

Youngcodger

 

[feherke]

Hi

Wrong. You have to use [tt]cut[/tt] + [tt]sort[/tt] + [tt]uniq[/tt] to achieve that.

cut -c 6-14 /input/file | sort | uniq -c

awk '{n[substr($0,6,9)]++}END{for(i in n)print i,n[i]}' /input/file

( In my sample I had 9 character long phone numbers starting at position 6. )

Feherke.

http://rootshell.be/~feherke/

 

[YOUNGCODGER]

Thanks Feherke! It gave me over 150,000 separate numbers and highlighted some nasty corruptions in the file.

Thanks again,

Young Codger