Shell Programming and Scripting

Hi All,

I have an input below and i would want to do a count on all the term "aaa" and count only once if the number in first column is the same.
For eg, if i use a "grep -c aaa input" command, the count will be "8".
However, i would want the count to be "6" instead since 2 numbers in the 1st column is repetitive and i wouldn;t want to do a double count. So can anybody show me how to edit the above grep command to get my desired output ?

Input:

111 aaa
111 aaa
222 aaa
333 aaa
444 aaa
444 aaa
555 aaa
666 aaa

Code:

uniq file | grep -c "aaa"

If the data is not sorted then sort the file and pass to uniq command

Hi anbu,

Thanks it works

Hi Anbu,

What if i want to count only when there are 2 occurence?
For the below example, the count would be "2" in this case since "111 aaa" and "444 aaa" are repetitive and have 2 or more occurence.

Code:

$ awk ' { arr[$0]++ } END { for( str in arr  ) { if ( arr[str] > 1 ) print str " " arr[str] } } ' file
111 aaa 2
444 aaa 2

Hi Anbu,

I don;t mean that.
What i mean is that for the below case, there are 3 sets(as highlighted) with 2 occurences so the count will be 3.

For eg,

Input:
111 aaa
111 aaa
222 aaa
333 aaa
444 aaa
444 aaa
555 aaa
666 aaa
666 aaa
777 aaa

Code:

uniq -d file | grep -c "aaa"