Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.
|
Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.
|
|
google unix.com
|
|||||||
| Forums | Register | Forum Rules | Links | Albums | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
 |
| 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 10:44 PM |
| Counting up a variable | Kenada | Shell Programming and Scripting | 3 | 07-18-2007 03: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 01:37 PM |
| Counting LOC in C | amatsaka | High Level Programming | 1 | 06-04-2002 03:18 PM |
 |
|
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | 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! |
|
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
|
| Sponsored Links | ||
|
|
Linear Mode
