Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Print line with highest value from one column Post 302534427 by dliving3 on Tuesday 28th of June 2011 01:44:38 AM
Old 06-28-2011
Print line with highest value from one column

Hi everyone,

This is my first post, but I have already received a lot of help from the forums in the past. Thanks!

I've searched the forums and my question is very similar to an earlier post entitled "Printing highest value from one column", which I am apparently not yet allowed to post a link to (only 4 more posts until I can spam!!Smilie).

My problem is that I have more columns, and want the whole line printed. For the example:

Line ID Sort Extra Extra2
1 A 3 4 3
2 A 1 2 1
3 A 2 3 2
4 A 1 1 1
5 B 1 1 1
6 B 1 2 1
7 B 3 3 3
8 C 1 1 1
9 D 3 1 3
10 E 3 1 3
11 E 3 2 3

I want to print one line for every unique ID value that has the highest value in Sort. Giving the output:

Line ID Sort Extra Extra2
1 A 3 4 3
7 B 3 3 3
8 C 1 1 1
9 D 3 1 3
11 E 3 2 3

If the sort value is equal for any given ID, I don't really care which is returned as in ID=E.

Franklin52's answer (modified for my data) in the previous post mentioned was close:
Code:
 awk 'a[$2] < $3{a[$2]=$3} END{for(i in a){print i, a[i]}}' file

However, I can't seem to get it to print the whole line. Please let me know what I am missing!

Thanks in advance!
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to print last column of line

Hello folks, Please guide me i have a file file.txt that have below text. PETER JOHN peter@example.com John Col john@example.com Sara Paul sara@example.com I just want to extract only email address list. (5 Replies)
Discussion started by: learnbash
5 Replies

2. Shell Programming and Scripting

read file line by line print column wise

I have a .csv file which is seperated with (;) inputfile --------- ZZZZ;AAAA;BBB;CCCC;DDD;EEE; YYYY;BBBB;CCC;DDDD;EEE;FFF; ... ... reading file line by line till end of file. while reading each line output format should be . i need to print only specific columns let say 5th... (2 Replies)
Discussion started by: rocking77
2 Replies

3. UNIX for Dummies Questions & Answers

Print line with highest value from one column

Hi everyone, This is my first post, but I have already received a lot of help from the forums in the past. Thanks! I've searched the forums and my question is very similar to an earlier post entitled "Printing highest value from one column", which I am apparently not yet allowed to post a... (3 Replies)
Discussion started by: dliving3
3 Replies

4. UNIX for Advanced & Expert Users

Print line based on highest value of col (B) and repetion of values in col (A)

Hello everyone, I am writing a script to process data from the ATP world tour. I have a file which contains: t=540 y=2011 r=1 p=N409 t=540 y=2011 r=2 p=N409 t=540 y=2011 r=3 p=N409 t=540 y=2011 r=4 p=N409 t=520 y=2011 r=1 p=N409 t=520 y=2011 r=2 p=N409 t=520 y=2011 r=3 p=N409 The... (4 Replies)
Discussion started by: imahmoud
4 Replies

5. Shell Programming and Scripting

Find lines with matching column 1 value, retain only the one with highest value in column 2

I have a file like: I would like to find lines lines with duplicate values in column 1, and retain only one based on two conditions: 1) keep line with highest value in column 3, 2) if column 3 values are equal, retain the line with the highest value in column 4. Desired output: I was able to... (3 Replies)
Discussion started by: pathunkathunk
3 Replies

6. Shell Programming and Scripting

awk Print New Column For Every Two Lines and Match On Multiple Column Values to print another column

Hi, My input files is like this axis1 0 1 10 axis2 0 1 5 axis1 1 2 -4 axis2 2 3 -3 axis1 3 4 5 axis2 3 4 -1 axis1 4 5 -6 axis2 4 5 1 Now, these are my following tasks 1. Print a first column for every two rows that has the same value followed by a string. 2. Match on the... (3 Replies)
Discussion started by: jacobs.smith
3 Replies

7. Shell Programming and Scripting

Print next line beside preceding line on column match

Hi, I have some data like below: John 254 Chris 254 Matt 123 Abe 123 Raj 487 Moh 487 How can i print it using awk to have: 254 John,Chris 123 Matt,Abe 487 Raj,Moh Thanks. (4 Replies)
Discussion started by: james2009
4 Replies

8. AIX

Print whole line with highest value from one column

Hi, I have a little issue right now. I have a file with 4 columns test0000002,10030010330,c_,218 test0000002,10030010330,d_,202 test0000002,10030010330,b_,193 test0000002,10030010020,c_,178 test0000002,10030010020,b_,170 test0000002,10030010330,a_,166 test0000002,10030010020,a_,151... (2 Replies)
Discussion started by: Ebk
2 Replies

9. Shell Programming and Scripting

Print whole line with highest value from one column

Hi, I have a little issue right now. I have a file with 4 columns test0000002,10030010330,c_,218 test0000002,10030010330,d_,202 test0000002,10030010330,b_,193 test0000002,10030010020,c_,178 test0000002,10030010020,b_,170 test0000002,10030010330,a_,166 test0000002,10030010020,a_,151... (3 Replies)
Discussion started by: Ebk
3 Replies

10. UNIX for Beginners Questions & Answers

awk print line with highest value

grepping on a value but then want to print only those lines that have the highest value in the 4th column log text text R59FJ log text text R63FT log text text R60JX log1 text text R63EA log1 text text R60JX desired output log text text R63FT log1 text text R63EAtried this but not getting... (2 Replies)
Discussion started by: jimmyf
2 Replies
post(8) 						      System Manager's Manual							   post(8)

NAME
post - deliver a message SYNOPSIS
/usr/lib/mh/post [options] file OPTIONS
Specifies a file that post should take aliases from. More than one file can be specified, each being preceded with the -alias option. The post program automatically consults the system alias file, /usr/lib/mh/MailAliases. If there is an Aliasfile entry in your post also con- sults the file named in that entry. Filters (re-formats) messages sent to blind copy recipients. Recipients named in the Bcc: field nor- mally receive a new message which includes a copy of the message sent to the other recipients. If this option is specified, this copy of the message is filtered according to the instructions in the named file. The default is -nofilter. Formats messages so as to conform to ARPAnet Internet Message Format protocol. This is the default behavior. You can post from formatting messages in this way by using the -noformat option. Prints a list of the valid options to this command. Adds a Message-ID: or Resent-Message-ID: field to the header. Specifies the mail system over which mail is sent. The only value allowed is smtp, which is the standard mail system. Additional values are supported only for use with other mail systems. Informs the user of each step of the posting/filing process. Allows the user to watch the transport system's handling of the message (for example, local and fast delivery). Specifies the preferred length of the header compo- nents that contain addresses. The default settings for post are: -alias /usr/lib/mh/MailAliases -format -nomsgid -mts smtp -noverbose -nowatch -width 72 -nofilter DESCRIPTION
The program post is called by send(1) to deliver the message in the named file to local and remote users. In fact, all of the functions at- tributed to send on its reference page are performed by post, with send acting as a relatively simple pre-processor. Thus, it is post which parses the various header fields, appends From: and Date: lines, and interacts with the transport system. Normally, post would not be called directly by the user. It searches the To:, cc:, Bcc:, and Resent-xxx: header lines of the specified message for destination addresses, checks these addresses for validity, and formats them so as to conform to ARPAnet Internet Message Format protocol (unless the -noformat option is set). This will normally cause @local-site to be appended to each local destination address, as well as any local return addresses. If a Bcc: field is encountered, the mail system will use its addresses for delivery. The Bcc: is removed from the message sent to original recipients. The copied recipients will receive an entirely new message with a minimal set of headers. The mail system includes a copy of the message sent to the original recipients in the body of the message. This command consults the environment variable $SIGNATURE to determine the sender's personal name in constructing the From: line of the message. RESTRICTIONS
For this version, the -mts option only supports the value smtp. Additional values are supported for use only with other mail systems. PROFILE COMPONENTS
The post command does not consult the user's FILES
The system customization file. The program to process Fcc:s. The program to process Bcc:s. The system alias file. SEE ALSO
Commands: comp(1), mhmail(1), send(1) Files: mh-alias(4), mh-mail(4), mtstailor(4) Standard for the Format of ARPA Internet Text Messages (RFC 822) post(8)
All times are GMT -4. The time now is 08:10 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy