Shell Programming and Scripting

Hi,

I have a script which greps for a word in a file contains records.
I grabbed a particular column & sent the colomn values to a file.
I need to find each column value, the times it appeared in the file.
My script is:
grep sceneority <file> | cut -f 6 >> swi

With above I grabbed the 6 th column and sent to swi file
I am stuck at how to find the occurance of column values in "swi" file.
Plz help me.
Ex:

The file has following column values:

123
324
123
123
435
435

The output should be

123 is 3 times
324 is 1 time
435 is 2 times

Thanks & Regards,
Pradeep.

Code:

sort file | uniq -c | sort -rn

This is pretty much the "hello world" of shell scripts.

Hi Thanks for the reply.

I have one more doubt.
If I grabbed 2 or more fileds to the file and and If I want to count on only one more field...how the sort should be....
for example,

grep sceneority <file> | cut -f 3,4,6 >> swi
I want to count on only 6th field....

Some extended versions of uniq have a flag to skip over some fields. In the general case, though, either write a simple awk script (if you need to keep the file intact, and somehow add this frequency count information) or just cut the field you want to count and proceed as previously.

In your new swi file, the former field 6 is field 3, obviously.

Code:

cut -f3 swi | sort | uniq -c | sort -rn

Without the use of the temporary file swi, grep, cut, sort and uniq:

Code:

awk '/sceneority/{a[$6]++}END{for(i in a){print i, a[i]}}' file

Regards