Finding max value - The UNIX and Linux Forums

		The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
Finding max value

google unix.com

Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Finding my DNS	jjinno	UNIX for Dummies Questions & Answers	2	07-17-2007 09:14 AM
finding duplicate files by size and finding pattern matching and its count	jerome Sukumar	Shell Programming and Scripting	2	12-01-2006 04:20 AM
Help finding a BOS	zuessh	AIX	1	07-25-2006 02:48 AM
Finding last row	indo1144	UNIX for Advanced & Expert Users	7	09-23-2005 03:25 AM
Finding how done IT	geoquest	UNIX for Dummies Questions & Answers	5	08-26-2002 10:12 AM


	Powered by

LinkBack

Thread Tools

Search this Thread

Rate Thread

Display Modes

#1 (permalink)

04-10-2005

Enigma23

Registered User

Join Date: Apr 2005

Posts: 6

Finding max value

My code below is supposed to find which company had the most business and then print the appropriate fields from another file which are the companies ID number and name. I can loop through awk and display all the total amount of business for each company but I need help in only printing out the total, Id, and name for the company with the highest sales amount. Plus, I am having problems only displaying the carrier id and name of each company but my script displays every carrier ID and company name.

Code:

#!/usr/bin/csh

set num = 1
set count = 5

while ($num <= $count)
awk 'BEGIN{count ='$num'}{if($2 == count) {x+=$5}} END{print x}' ShippingOrders.
tab
awk 'BEGIN{count = '$num'}{if($1 == count}{print $1,$2,$3}' Shippers.tab
@ num = $num + 1
end

Bookmarks

« procmailrc | checking file's permissions and change them »

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 Switch to Hybrid Mode Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On Forum Rules

All times are GMT -4. The time now is 06:11 AM.