Newbie Awk data sorting

i_am_a_robot · #1 (**permalink**) 05-04-2007

Hi guys, just started using awk here.

I've got a file called a.txt which contains a load of numbers on each line e.g.

35
232
654
1
9
4

I want to learn how to do three things:

1. Find the minimum
2. Find the maximum
3. Find the average

I want to learn how to do this using awk. Pretty basic stuff I should think but all I'm new to this so help please.

anbu23 · #2 (**permalink**) 05-04-2007

Please make a try. If you are not able to do we will help you.

i_am_a_robot · #3 (**permalink**) 05-04-2007

well I've been trying to put it into an array using

split {$1, myArray, "\n"}

and

myArray{$1}

but it just throws out a load of errors.

anbu23 · #4 (**permalink**) 05-04-2007

Quote:

Originally Posted by i_am_a_robot

well I've been trying to put it into an array using

split {$1, myArray, "\n"}

and

myArray{$1}

but it just throws out a load of errors.

Awk processes the file line by line. I suggest you to read any tutorials on awk before you proceed to solve the problems. You can search the forum for awk tutorial.

ghostdog74 · #5 (**permalink**) 05-04-2007

one way find min

Code:

awk 'NR==1 { temp = $1 ;next}
     { if ( $1 <= temp ) { temp=$1 }  }  
END{ print temp}' "file"

I leave you to do finding of max...

find avg

Code:

awk 'BEGIN{count=0}
     { count = count + $1} 
END{ print count/NR}' "file"

reborg · #6 (**permalink**) 05-04-2007

(6) Do not post classroom or homework problems.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Sorting your data with msort	iBot	UNIX and Linux RSS News	0	05-19-2008 11:20 AM
Sorting data and place them in different folders	Vinaykumar1	UNIX for Dummies Questions & Answers	29	05-14-2008 08:47 AM
sorting data using array in ksh	ali560045	Shell Programming and Scripting	4	12-04-2007 04:26 AM
Sorting blocks of data	alfredo123	Shell Programming and Scripting	8	07-05-2007 10:53 AM
sorting data based on multi columns	sumeet	UNIX for Advanced & Expert Users	2	02-15-2007 12: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