UNIX for Dummies Questions & Answers

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!

I'm not sure what the 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

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!

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}'

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