Number count per number ranges

shirleyeow · #1 (**permalink**) 12-18-2007

Hi,

I have a question here that need to get advise from all of you. Let say I have a set of data

12347777
12359899
12347677
12360090
12347688
12359979
12359009
12367022
12346677

I need to count the number that appear in each numbering ranges and the output is like below:

Prefix Count
1234 4
1235 3
1236 2

How can I do this by using shell script? What command that I can use? Please advise. Really appreaciate your help. Thank you so much.

Best Regards,
Shirley

vgersh99 · #2 (**permalink**) 12-18-2007

Code:

nawk  '
{
  arr[substr($1, 1, 4)]++
}
END {
  for (i in arr)
    print i, arr[i]
}' myFile

shirleyeow · #3 (**permalink**) 12-18-2007

Hi vgersh99,

I have tested on the script with test data, but no output is showing. The output file is empty. Tried to modify the script, but still the same.

Please advise.

Thank you so much.

Best Regards,
Shirley

vgersh99 · #4 (**permalink**) 12-18-2007

given a sample input provided I get:

Code:

1236 2
1235 3
1234 4

Pls provide your exact input data using vB Codes

ranjithpr · #5 (**permalink**) 12-18-2007

cut -c1-4 filename|sort|uniq -c

shirleyeow · #6 (**permalink**) 12-19-2007

Hi vgersh99 and ranjithpr,

The script is working now and I able to get the output data that I needed.
Thank you so so so much for your helps.

Thank you.

Best Regards,
Shirley

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
count number of files in a directory	finalight	Shell Programming and Scripting	5	05-14-2009 07:57 AM
How count number of fields in a record	sureshg_sampat	Shell Programming and Scripting	5	01-07-2008 06:30 AM
Finding number ranges using grep	DKNUCKLES	Shell Programming and Scripting	2	11-07-2007 02:30 AM
Count number of files in subdirectories	cbeverly	UNIX for Dummies Questions & Answers	2	06-02-2005 03:06 PM
Count Number Of Threads in a Process	S.P.Prasad	High Level Programming	7	01-02-2003 06:04 AM

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


	Powered by