how can i count # times string is repeated ?

NickPats · 10-14-2012, 10:14 AM

Greg
Anne Murai
Anne Murai
John-Paul
David Conley
David Conley
Vasco da Gamma
adrianne
kevin
charles manus
Hugh Kenrick
Austin Dsouza
Austin Dsouza

how can i print the name and num of times it is used ?

kooru · 10-14-2012, 10:53 AM

If you have the strings into a file called, for example, list.txt:

Code:

sort list.txt | uniq -c

porphyry5 · 10-14-2012, 01:08 PM

Or if you want the details of a single name from a long list, add a grep

Code:

~ $ cat >> list.txt
Greg
Anne Murai
Anne Murai
John-Paul
David Conley
David Conley
Vasco da Gamma
adrianne
kevin
charles manus
Hugh Kenrick
Austin Dsouza
Austin Dsouza
~ $ sort list.txt | uniq -c | grep -i david
      2 David Conley
~ $

David the H. · 10-15-2012, 01:37 AM

Code:

awk '{ a[$0]++ } END{ for (i in a) { print i ": " a[i] } }' infile.txt | sort

awk 'BEGIN{ PROCINFO["sorted_in"]="@ind_str_asc" } { a[$0]++ } END{ for (i in a) { print i ": " a[i] } }' infile.txt

This uses awk's associative arrays. Each array index is the line itself, and the value increments once each time the same line is encountered. Then at the end we just loop through the array and print the values.

In the first version, we pipe it through sort afterwards in order to get sorted output. If you're using gawk v.4+ you can use the second variation, as it has array sorting built in.