Counting and sort

bobo · #1 (**permalink**) 05-23-2006

Hello friends,

I have the following data:

abc-xyz
abc = 0-999
xyz = 0-999

and there are 10000 lines or more:

Example of data file:

123000
123001
123004
123005
123004
123004
123008
123008
123008
123008
246599
246700
246999
246999
246999
246999
246999
246888
246881
246999
357001
357888
357999
357999
357999
357999
357999
357999
357999
357999

I am looking for a script which will count the number of times the same number repeat. My result from the given data above should be:

123000 1
123001 1
123004 3
123005 1
123008 4
246599 1
246700 1
246881 1
246888 1
246999 6
357001 1
357888 1
357999 8

Thanks!

jim mcnamara · #2 (**permalink**) 05-23-2006

I'm not sure what the

Quote:

abc-xyz
abc = 0-999
xyz = 0-999

has to do with anything. but for your column of numbers try:

Code:

awk '
      {arr[$0]++}
      END { for(i in arr) 
              { print $i, arrr[i] }
      } '  filename > newfilename

bobo · #3 (**permalink**) 05-23-2006

Thanks for the help. It is not working: data range :0-999999

Data sample:

123000
123001
123004
123005
123004
123004
123008
123008
123008
123008
246599
246700
246999
246999
246999
246999
246999
246888
246881
246999
357001
357888
357999
357999
357999
357999
357999
357999
357999
357999

Expect data result from the script:

123000 1
123001 1
123004 3
123005 1
123008 4
246599 1
246700 1
246881 1
246888 1
246999 6
357001 1
357888 1
357999 8

Thanks!

Glenn Arndt · #4 (**permalink**) 05-23-2006

Code:

uniq -c myfile.txt

yields:

1 123000
1 123001
1 123004
1 123005
2 123004
4 123008
1 246599
1 246700
5 246999
1 246888
1 246881
1 246999
1 357001
1 357888
8 357999

If you really need to have the results like:

357888 1
357999 8

you can use a simple awk script:

Code:

uniq -c myfile.txt | awk '{print $2, $1}'

reborg · #5 (**permalink**) 05-23-2006

There were just a couple of typos in Jim's solution, here is what he intended to post.

Code:

awk '
      {arr[$0]++}
      END { for(i in arr) 
              { print i, arr[i] }
      } '  filename > newfilename

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
urgent help in counting	sunitachoudhury	Shell Programming and Scripting	2	05-20-2008 11:44 PM
Counting up a variable	Kenada	Shell Programming and Scripting	3	07-18-2007 04:07 AM
Counting Processes	heprox	Shell Programming and Scripting	4	03-21-2007 05:44 AM
Help with counting files please	gerard1	Shell Programming and Scripting	6	09-25-2006 02:37 PM
Counting LOC in C	amatsaka	High Level Programming	1	06-04-2002 04:18 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by