Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Uniq adresses with number of occurrence

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Uniq adresses with number of occurrence
# 1  
Old 11-12-2010
Uniq adresses with number of occurrence
Alo

I have a file with a lot of addresses where I want to list unique addresses and the number of theirs occurrence.

I have this input file:
Code:
0011bd09  ea 01 0b 04 ea 01 0b 38-bd 11 00 98 15 cb 01 00  .......8........
0011bd09  ea 11 00 98 15 cb 01 00-00 00 00 d8 3d 8d 01 94  ............=...
0011bd0d  ea 01 0b 38 bd 11 00 98-15 cb 01 00 00 00 00 d8  ...8............
0011bd21  ea 01 0b 00 00 00 00 00-00 00 00 e9 2a f5 27 54  ............*.'T
0011e9f9  ea 11 00 98 15 cb 01 00-00 00 00 d8 3d 8d 01 94  ............=...
0011ea21  ea 11 00 98 15 cb 01 00-00 00 00 d8 3d 8d 01 e4  ............=...

And I want something like this (order by number of occurrence):
Code:
0011bd09  2
0011bd0d  1
0011bd21  1
0011e9f9  1
0011ea21  1

I am thinking about using uniq combined with sort but I only want to uniq on the address and not the hole line

Thx in advance
Last edited by Scott; 11-12-2010 at 03:45 PM.. Reason: Code tags
# 2  
Old 11-12-2010
Hope this helps:
Code:
awk '{print $1}' inputfile | uniq -c | awk '{print $2" "$1}'

Last edited by Scott; 11-12-2010 at 03:45 PM.. Reason: Code tags
This User Gave Thanks to in2nix4life For This Post:
chitech
# 3  
Old 11-12-2010
Thx for the answer but it's not working correctly. All lines get 1 occurrence. But if I use this:

Code:
awk '{print $1}' inpufFile | sort | uniq -c | sort | awk '{print $2" "$1}'

I will get the right result. The first sort is to make uniq -c count correctly and the second sort is to sort the occurrence
# 4  
Old 11-12-2010
No problem. Interesting. On my distro (Arch Linux), it yielded the correct output without the 'sorts', but the bottomline is you got the answer you were looking for.
# 5  
Old 11-12-2010
Here's a Perl solution -

Code:
$
$
$ # show the content of the data file "f7"
$
$ cat f7
0011bd09 ea 01 0b 04 ea 01 0b 38-bd 11 00 98 15 cb 01 00 .......8........
0011bd09 ea 11 00 98 15 cb 01 00-00 00 00 d8 3d 8d 01 94 ............=...
0011bd0d ea 01 0b 38 bd 11 00 98-15 cb 01 00 00 00 00 d8 ...8............
0011bd21 ea 01 0b 00 00 00 00 00-00 00 00 e9 2a f5 27 54 ............*.'T
0011e9f9 ea 11 00 98 15 cb 01 00-00 00 00 d8 3d 8d 01 94 ............=...
0011ea21 ea 11 00 98 15 cb 01 00-00 00 00 d8 3d 8d 01 e4 ............=...
0011bd0d xx 01 0b 38 bd 11 00 98-15 cb 01 00 00 00 00 d8 ...8............
0011bd0d yy 01 0b 38 bd 11 00 98-15 cb 01 00 00 00 00 d8 ...8............
$
$ # run the Perl script on "f7"
$
$ perl -lane '$x{$F[0]}++;
              END {
                while (($k, $v) = each %x) {push @y,"$k:$v"}
                @z = sort {(split ":",$b)[1] <=> (split ":",$a)[1]} @y;
                do {s/:/ /; print} for (@z)}
             ' f7
0011bd0d 3
0011bd09 2
0011ea21 1
0011bd21 1
0011e9f9 1
$
$

tyler_durden
# 6  
Old 11-12-2010
Only awk and sort.
Code:
awk '{a[$1]++}END{for(i in a) print i,a[i]|"sort -rk2"}' file

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk or other way to find out number of occurrence of 7th character

Hi all, I am looking for to filter out based on 7th character and list the number of occurrence based on the 7th character if p , d , o or m 1. if 7th character is p , Output should be: p_hosts = N 2. if 7th character is d , Output should be: d_hosts = N 3. if 7th character is o , Output... (10 Replies)
Discussion started by: rveri
10 Replies

2. Shell Programming and Scripting

awk to find the number of occurrence

My file contains like this on 10 th line NM1*IL*1* awk '/NM1/{print NR}' *.dat output is 10 awk '/NM1*IL*1*/{print NR}' *.dat output is Nothing but im expecting 10 on second code as well . (4 Replies)
Discussion started by: Rajesh_us
4 Replies

3. Shell Programming and Scripting

How to count the occurrence of a number?

Hi, I have a file which contained a set of numbers like Col1 col2 col3 col4 1 sa 13 0 2 sb 14 0 3 sc 15 9 4 sd 16 -9 5 sd 20 -2 6 sd 20 4 Here in last column I need to count the zeros, positive values and negative values, please help me to do that. (2 Replies)
Discussion started by: Shenbaga.d
2 Replies

4. Shell Programming and Scripting

Count number of occurrence of a string in file

if there's a file containing: money king money queen money cat money also money king all those strings are on one line in the file. how can i find out how many times "money king" shows up in the line? egrep -c "money king" wont work. (7 Replies)
Discussion started by: SkySmart
7 Replies

5. Shell Programming and Scripting

number of occurrence

: i need a bash script to convert the displayed output 12 14 15 12 15 13 to 12 * 2 ,13 * 1,14*1,15*1 Thanks, nevil (2 Replies)
Discussion started by: nevil
2 Replies

6. Shell Programming and Scripting

Count number of occurrence at each line

Hi I have the following file ENST001 ENST002 4 4 4 88 9 9 ENST004 3 3 3 99 8 8 ENST009 ENST010 ENST006 8 8 8 77 8 8 Basically I want to count how many times ENST* is repeated in each line so the expected results is 2 1 3 Any suggestion please ? (4 Replies)
Discussion started by: fuad_
4 Replies

7. Shell Programming and Scripting

Replace x Number of String Occurrence with Sed

Ok, So I have a huge file that has over 12000 lines in it. in this file, there are 589 occurrences of the string "use five-minute-interval" spread in various areas in the file. How can i replace the the last 250 of the occurrences of "use five-minute-interval" with "use... (10 Replies)
Discussion started by: SkySmart
10 Replies

8. UNIX for Dummies Questions & Answers

line number of the i-th occurrence of a pattern

Hi all, is there a simple way to obtain the line number of the i-th occurrence of a pattern? I have OCCURRENCE=`grep -io "${STRING_NAME}" ${1}-${8}${EXT}.out_bis| wc -l` which tells me how many occurency I have. I would like to go through them and determine the line number and assign... (6 Replies)
Discussion started by: f_o_555
6 Replies

9. UNIX for Dummies Questions & Answers

Line number of an occurrence using grep

Hi All, is there a way to extract the line number of an occurrence using grep? I know that with the -n option it prints out the line number as well. I would like to assign the line number to a variable. Thanks, Sarah (5 Replies)
Discussion started by: f_o_555
5 Replies

10. UNIX for Dummies Questions & Answers

optimizing - to find the number of occurrence

Hi, I need to find the number of occurrence of string in a file, for ex: >cat filename abc abc def ghi ghi ghi ghi abc abc >output would be abc 4 def 1 (10 Replies)
Discussion started by: matrixmadhan
10 Replies
Login or Register to Ask a Question