bash calculate repeated lines

nushki · 01-28-2010, 03:16 AM

Dear all,

i have a sorted file with many repeated lines like this:
1ujw
1ujw
1ul1
1us7
1us7
1us7
1us7
1us7
1uuz
1uuz
1uuz
1uuz
1uuz
1uuz
1uuz
1uzx
1uzx
1uzx

i need to calculated haw many times each line is repeated, for ex
1ujw 2
1ul1 1
1us7 5
etc.

many thanks

ghostdog74 · 01-28-2010, 03:22 AM

Code:

uniq -c file

druuna · 01-28-2010, 03:27 AM

Hi,

Something like this?

awk '{count[$1]++}END{for(j in count) print j,"("count[j]")"}' infile

Output of testrun:

Code:

$ awk '{count[$1]++}END{for(j in count) print j,"("count[j]")"}' infile
1ujw (2)
1uuz (7)
1uzx (3)
1us7 (5)
1ul1 (1)

Hope this helps.

druuna · 01-28-2010, 03:29 AM

@ghostdog74: That's an option (uniq -c) I did not know about yet.... Nice short solution!

nushki · 01-28-2010, 03:38 AM

Quote:

Originally Posted by ghostdog74

Code:

uniq -c file

thank you very much. very elegant way!!!

bigearsbilly · 01-28-2010, 04:27 AM

if you use uniq you need to sort first.

edit:
d'oh I see you have!