how to use awk to sort this problem out

sonicstage · #1 (**permalink**) 04-07-2008

there has several numbers which are:1,2,3,45,6,7,8,9,0,10,34,34,54,122,6756,54,87,99,2,1,45;

how to write a shell script orts the above numbers into descending order and puts them into and arrray and also find and prints the minimum and maximum of those numbers, and finds and prints the average of the numbers.

the outputs should be like:

minimum number:2
maximum number:10
average:5

Yogesh Sawant · #2 (**permalink**) 04-07-2008

is this homework?

what have you tried so far?

sonicstage · #3 (**permalink**) 04-07-2008

please teach me how to do it

summer_cherry · #4 (**permalink**) 04-07-2008

why the max is 10 but not 6756 while the min is 1 but not 0.

If the requirement is what i assumed as above. Follow code can fullfill it.

Code:

filename:b

awk 'BEGIN{RS=","}
{
print 
}' b> c
sort -n c > c.t
rm c
sed '/^$/d' c.t > c
rm c.t
echo "min=`head -1 c`"
echo "max=`tail -1 c`"
echo "avg=`awk '{n=n+$0}END{print n/NR}' c`

aigles · #5 (**permalink**) 04-07-2008

Another way with awk :

Code:

awk -v RS="," '
   NF && min=="" {
      min = max = $1 ;
   }
   NF {
     if ($1 > max) max = $1;
     if ($1 < min) min = $1;
     sum += $1
     cnt += 1
   }
   END {
      print "minimum number:" min;
      print "maximum number:" max;
      print "average:" sum/cnt;
   }
    ' inputfile

Jean-Pierre.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
sort problem	talashil	Shell Programming and Scripting	4	04-11-2008 04:56 PM
sort -k	Indalecio	Shell Programming and Scripting	4	03-16-2007 04:00 AM
Sorting problem "sort -k 16,29 sample.txt > output.txt"	ganapati	Shell Programming and Scripting	3	08-01-2006 06:55 AM
SORT problem on SUN	bobk544	UNIX for Dummies Questions & Answers	2	06-29-2006 04:46 PM
Problem with sort	jyoung	UNIX for Dummies Questions & Answers	1	04-13-2006 01:57 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