Awk Question (Simple)

[itrylinuxandlike]

Hello Everyone,

I have a .txt file with usernames. The file reads:

user1
user1
user1
user1
user2
user2
user2
user3
user3
user3
user3

And so on. With Awk, how do I select only the user# that are shown 4 times? So in another file it would read:
user1
user1
user1
user1
user3
user3
user3
user3

THANK YOU!!!!

 

[PHV]

awk '{++a[$1]}END{for(u in a)if(a==4)for(i=0;i<4;++i)print u}' users.txt

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Annihilannic]

Also uniq -c filename | awk '$1 == 4 {print $2}'

Annihilannic.

 

[risby]

or rather

uniq -c filename | awk '$1 == 4 {for (i=1; i<5; i++) print $2}'

 

[Annihilannic]

True, true, thanks.

Annihilannic.