LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - General
User Name
Password
Linux - General This Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.

Notices



Reply
 
Search this Thread
Old 12-04-2013, 05:43 AM   #1
phpshell
Member
 
Registered: Nov 2012
Posts: 46

Rep: Reputation: Disabled
duplication count and show


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

Last edited by onebuck; 12-04-2013 at 04:16 PM. Reason: typo
 
Old 12-04-2013, 06:13 AM   #2
syg00
LQ Veteran
 
Registered: Aug 2003
Location: Australia
Distribution: Lots ...
Posts: 12,491

Rep: Reputation: 1077Reputation: 1077Reputation: 1077Reputation: 1077Reputation: 1077Reputation: 1077Reputation: 1077Reputation: 1077
And your attempts so far have been ?.
 
Old 12-04-2013, 04:10 PM   #3
phpshell
Member
 
Registered: Nov 2012
Posts: 46

Original Poster
Rep: Reputation: Disabled
duplication count and show

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 ~]#
 
Old 12-05-2013, 06:37 PM   #4
danielbmartin
Senior Member
 
Registered: Apr 2010
Location: Apex, NC, USA
Distribution: Ubuntu
Posts: 1,165

Rep: Reputation: 306Reputation: 306Reputation: 306Reputation: 306
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

Last edited by danielbmartin; 12-05-2013 at 09:17 PM. Reason: Improved code
 
1 members found this post helpful.
Old 12-08-2013, 12:20 AM   #5
phpshell
Member
 
Registered: Nov 2012
Posts: 46

Original Poster
Rep: Reputation: Disabled
your the man
well done danielbmartin .
many thanks to you
 
Old 12-09-2013, 08:38 AM   #6
danielbmartin
Senior Member
 
Registered: Apr 2010
Location: Apex, NC, USA
Distribution: Ubuntu
Posts: 1,165

Rep: Reputation: 306Reputation: 306Reputation: 306Reputation: 306
Quote:
Originally Posted by phpshell View Post
many thanks to you
You are welcome. In future, such questions should be posted in the Linux Questions Programming forum.

Daniel B. Martin
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] MySql order by COUNT and list the total count countrydj Programming 3 07-19-2012 01:21 PM
Warning: [fnn_insert] Column count doesn't match value count at row 1 in bondoq Programming 2 09-27-2011 05:11 PM
DBD::mysql::st execute failed: Column count doesn't match value count at row 1 shifter Programming 2 02-24-2010 08:42 PM
Need a way to count sub-directories and get a total count Mo-regard Linux - Newbie 1 08-14-2009 10:10 AM
Should posts in general count on your post count? Joey.Dale General 16 01-27-2004 02:31 AM


All times are GMT -5. The time now is 05:08 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration