[SOLVED] duplication count and show

phpshell · 12-04-2013, 04:43 AM

actually I am looking for awk script or for loop to count duplication on user and get the ip for each duplication

my file

192.168.1.168 abdulatif
192.168.1.64 amr
192.168.1.98 amr
192.168.1.34 ayoup
192.168.1.35 eshal
192.168.1.21 farma
192.168.1.191 hanan
192.168.1.125 hane
192.168.1.30 hane
192.168.1.249 majde
192.168.1.40 malbak
192.168.1.227 mjut
192.168.1.117 oct

output should be

amr use 192.168.1.64 & 192.168.1.98 || hane use 192.168.1.125 & 192.168.1.30

syg00 · 12-04-2013, 05:13 AM

And your attempts so far have been ?.

phpshell · 12-04-2013, 03:10 PM

here is my attempt
[root@proxy ~]# awk 'a[$2]++==1' test | awk '{print $2" use " $1}' | tr '\n' '|||'
amr use 192.168.1.98|hane use 192.168.1.30|
[root@proxy ~]#

danielbmartin · 12-05-2013, 05:37 PM

With this InFile ...

Code:

192.168.1.168 abdulatif
192.168.1.64 amr
192.168.1.98 amr
192.168.1.34 ayoup
192.168.1.35 eshal
192.168.1.21 farma
192.168.1.191 hanan
192.168.1.125 hane
192.168.1.30 hane
192.168.1.249 majde
192.168.1.40 malbak
192.168.1.227 mjut
192.168.1.117 oct

... this code ...

Code:

awk '{a[$2]=a[$2]" "$1" &"} 
  END{for (j in a) if (length(a[j])>20) print j,"use"a[j]}' $InFile  \
|sed 's/ &$//'     \
|sort              \
|paste -sd\|       \
|sed 's/|/ || /g'  \
>$OutFile

... produced this OutFile ...

Code:

amr use 192.168.1.64 & 192.168.1.98 || hane use 192.168.1.125 & 192.168.1.30

Daniel B. Martin

phpshell · 12-07-2013, 11:20 PM

your the man
well done danielbmartin .
many thanks to you

danielbmartin · 12-09-2013, 07:38 AM

Quote:

Originally Posted by phpshell

many thanks to you

You are welcome. In future, such questions should be posted in the Linux Questions Programming forum.

Daniel B. Martin