|
|
|
|
|||||||
| UNIX for Dummies Questions & Answers If you're not sure where to post a UNIX or Linux question, post it here. All UNIX and Linux newbies welcome !! |
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 07:44 PM |
| Counting up a variable | Kenada | Shell Programming and Scripting | 3 | 07-18-2007 12:07 AM |
| Counting Processes | heprox | Shell Programming and Scripting | 4 | 03-21-2007 01:44 AM |
| Help with counting files please | gerard1 | Shell Programming and Scripting | 6 | 09-25-2006 10:37 AM |
| Counting LOC in C | amatsaka | High Level Programming | 1 | 06-04-2002 12:18 PM |
 |
|
|
Submit Tools | LinkBack | Thread Tools | Display Modes |
05-23-2006
|
|||
|
|||
Counting and sort
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! 
|
| Forum Sponsor | ||
|
|
|
05-23-2006
|
|||
|
|||
|
I'm not sure what the
Quote:
Code:
awk '
{arr[$0]++}
END { for(i in arr)
{ print $i, arrr[i] }
} ' filename > newfilename
|
|
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!
|
|
05-23-2006
|
||||
|
||||
|
Code:
uniq -c myfile.txt 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}'
|
|
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
|
||||
| Google UNIX.COM |
|
| Thread Tools | |
| Display Modes | |
|
|
Asteroids Champion!
Hexxagon Champion!
Linear Mode
