Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Printing highest value from one column Post 302320454 by AlanBLDN on Thursday 28th of May 2009 04:57:03 AM
Old 05-28-2009
I have put your values into a test file, a.txt

cat a.txt

s6 98
s6 91
s6 56
s5 32
s5 10
s5 4

The following gives you what you want:

sort a.txt | awk 'BEGIN {x="";y=0;cnt=0;}{if (x != $1) {if (cnt > 0) {print x" "y};cnt=cnt+1;x=$1;y=$2};if (y<$2) {y=$2}}END{print x" "y}'

s5 32
s6 98
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

trying to make an AWK code for ordering numbers in a column from least to highest

Hi all, I have a large column of numbers like 5.6789 2.4578 9.4678 13.5673 1.6589 ..... I am trying to make an awk code so that awk can easily go through the column and arrange the numbers from least to highest like 1.6589 2.4578 5.6789 ....... can anybody suggest, how can I do... (5 Replies)
Discussion started by: ananyob
5 Replies

2. 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... (1 Reply)
Discussion started by: dliving3
1 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. Shell Programming and Scripting

Printing highest value from a list

Hi all, I'm trying to get the item with the maximum value, and was wondering if someone can help me with it. Heres my input file: apples 15 books 15 books 17 pens 12 pens 15 umbrella 13Here's what my output file should look like: apples 15 books 17 pens 15 umbrella 13 Can... (2 Replies)
Discussion started by: r4v3n
2 Replies

5. Shell Programming and Scripting

top 10 highest and lowest percentile from a column

Hi, I want to extract the the top 10 and lowest 10 percentile for a column of values. For example in column 2 for this file: JOE 1 JAY 5 JAM 6 JIL 8 JIB 4 JIH 3 JIG 2 JIT 7 JAM 9 MAR 10 The top 10 lowest will be: JOE 1 and the top 10 highest will be: (2 Replies)
Discussion started by: kylle345
2 Replies

6. Shell Programming and Scripting

Printing the lines of the string with highest value

Please help . The script need to first grep for all lines with "C:" as it contains a value Here the value is 0 1,00: This , is a good script c:0 and then give output of the lines with top 3 highest value for c: 1,00: This , is a nice script c:9999 1,00: This , is a... (3 Replies)
Discussion started by: necro98
3 Replies

7. 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

8. UNIX for Dummies Questions & Answers

Awk, highest and lowest value of a column

Hi again! I am still impressed how fast I get a solution for my topic "average specific column value awk" yesterday. The associative arrays in awk work fine for me! But now I have another question for the same project. Now I have a list like this 1 -0.1 1 0 1 0.1 2 0 2 0.2 2 -0.2 How... (10 Replies)
Discussion started by: bjoern456
10 Replies

9. 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

10. 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
hipercdecode(1) 					      General Commands Manual						   hipercdecode(1)

NAME
hipercdecode - Decode a HIPERC stream into human readable form. SYNOPSIS
hipercdecode [options] <hiperc-file DESCRIPTION
hipercdecode decodes a HIPERC stream into human readable form. Uncompressed and JBIG formats are handled. An HIPERC stream is the printer langauge used by the Oki Data C310dn, C3100, C3200n, C3250n, C3300n, C3400n, C5100n, C5250n, C5500n, C5600, and the C5800n printers. COMMAND LINE OPTIONS
These are the options that can appear on the command line. -d basename Basename of .pbm file for saving decompressed planes. -h Print hex file offsets. -o Print file offsets. -D level Set Debug level [0]. EXAMPLES
Decode an HIPERC stream file created by foo2hiperc. $ foo2hiperc-wrapper testpage.ps | hipercdecode -h 0: 33%-12345X@PJL f: @PJL RDYMSG DISPLAY = "Unknown" 30: @PJL SET OKIJOBACCOUNTJOB USERID="Unknown" JOBNAME="Unknown" 6e: @PJL SET OKIAUXJOBINFO DATA="DocumentName=Unknown" a2: @PJL SET OKIAUXJOBINFO DATA="ComputerName=dual.rkkda.org" dd: @PJL SET OKIAUXJOBINFO DATA="ReceptionTime=00:00:00 2008/01/30" 11e: @PJL SET OKIAUTOTRAYSWITCH=ON 13d: @PJL SET OKIPAPERSIZECHECK=ENABLE 160: @PJL SET RESOLUTION=600 179: @PJL SET PAPER=LETTER 190: @PJL SET OKITRAYSEQUENCE=PAPERFEEDTRAY 1b8: @PJL SET OKIPAPERFEED=TRAY1 1d5: @PJL SET OKIMEDIATYPE = PLAIN 1f4: @PJL SET LPARM:PCL OKIPRINTMARGIN=INCH1D6 21f: @PJL SET COPIES=1 232: @PJL SET QTY=1 242: @PJL SET HIPERCEFFECTIVEBLOCKSIZE=34799360 26e: @PJL ENTER LANGUAGE=HIPERC 289: RECTYPE 0 (len=52,0x34 cnt=1) 291: BLKNUM 0, nbie=1, pn=3 [black] uc=0,0, wid=4864 ud=0,100 2a5: BLKNUM 1 (len=20), uncompressed=1, bie: DL = 48, D = 48, P = 49, - = 48, XY = 4864 x 6816 L0 = 256, MX = 0, MY = 0 Order = 0 Options = 0 1 stripes, 0 layers, 49 planes 2bd: RECTYPE 1 (len=155668,0x26014 cnt=1) 2c5: BLKNUM 0 (len=4), plane=3, uc=0,0,0 2cd: BLKNUM 1 (len=155648), Data=00 00 00 00 00 00 00 00 00 00 00 ... 262d1: RECTYPE 1 (len=155668,0x26014 cnt=2) 262d9: BLKNUM 0 (len=4), plane=3, uc=0,0,0 262e1: BLKNUM 1 (len=155648), Data=00 00 00 00 00 00 00 00 00 00 00 ... 4c2e5: RECTYPE 1 (len=155668,0x26014 cnt=3) 4c2ed: BLKNUM 0 (len=4), plane=3, uc=0,0,0 4c2f5: BLKNUM 1 (len=155648), Data=00 00 00 00 00 00 00 00 00 00 00 ... 722f9: RECTYPE 1 (len=155668,0x26014 cnt=4) 72301: BLKNUM 0 (len=4), plane=3, uc=0,0,0 72309: BLKNUM 1 (len=155648), Data=00 00 00 00 00 00 00 00 00 00 00 ... 9830d: RECTYPE 1 (len=155668,0x26014 cnt=5) 98315: BLKNUM 0 (len=4), plane=3, uc=0,0,0 9831d: BLKNUM 1 (len=155648), Data=00 00 00 00 00 00 00 00 00 00 00 ... be321: RECTYPE 1 (len=155668,0x26014 cnt=6) be329: BLKNUM 0 (len=4), plane=3, uc=0,0,0 be331: BLKNUM 1 (len=155648), Data=00 00 00 00 00 00 00 00 00 00 00 ... e4335: RECTYPE 1 (len=155668,0x26014 cnt=7) e433d: BLKNUM 0 (len=4), plane=3, uc=0,0,0 e4345: BLKNUM 1 (len=155648), Data=00 00 00 00 00 00 00 00 00 00 00 ... 10a349: RECTYPE 1 (len=155668,0x26014 cnt=8) 10a351: BLKNUM 0 (len=4), plane=3, uc=0,0,0 10a359: BLKNUM 1 (len=155648), Data=00 00 00 00 00 00 00 00 00 00 00 ... 13035d: RECTYPE 1 (len=155668,0x26014 cnt=9) 130365: BLKNUM 0 (len=4), plane=3, uc=0,0,0 13036d: BLKNUM 1 (len=155648), Data=00 00 00 00 00 00 00 00 00 00 00 ... 156371: RECTYPE 1 (len=155668,0x26014 cnt=10) 156379: BLKNUM 0 (len=4), plane=3, uc=0,0,0 156381: BLKNUM 1 (len=155648), Data=00 00 00 00 00 00 00 00 00 00 00 ... 17c385: RECTYPE 1 (len=155668,0x26014 cnt=11) 17c38d: BLKNUM 0 (len=4), plane=3, uc=0,0,0 17c395: BLKNUM 1 (len=155648), Data=00 00 00 00 00 00 00 00 00 00 00 ... 1a2399: RECTYPE 1 (len=155668,0x26014 cnt=12) 1a23a1: BLKNUM 0 (len=4), plane=3, uc=0,0,0 1a23a9: BLKNUM 1 (len=155648), Data=00 00 00 00 00 00 00 00 00 00 00 ... 1c83ad: RECTYPE 1 (len=155668,0x26014 cnt=13) 1c83b5: BLKNUM 0 (len=4), plane=3, uc=0,0,0 1c83bd: BLKNUM 1 (len=155648), Data=00 00 00 00 00 00 00 00 00 00 00 ... 1ee3c1: RECTYPE 1 (len=155668,0x26014 cnt=14) 1ee3c9: BLKNUM 0 (len=4), plane=3, uc=0,0,0 1ee3d1: BLKNUM 1 (len=155648), Data=00 00 00 00 00 00 00 00 00 00 00 ... 2143d5: RECTYPE 1 (len=155668,0x26014 cnt=15) 2143dd: BLKNUM 0 (len=4), plane=3, uc=0,0,0 2143e5: BLKNUM 1 (len=155648), Data=00 00 00 00 00 00 00 00 00 00 00 ... 23a3e9: RECTYPE 1 (len=155668,0x26014 cnt=16) 23a3f1: BLKNUM 0 (len=4), plane=3, uc=0,0,0 23a3f9: BLKNUM 1 (len=155648), Data=00 00 00 00 00 00 00 00 00 00 00 ... 2603fd: RECTYPE 1 (len=155668,0x26014 cnt=17) 260405: BLKNUM 0 (len=4), plane=3, uc=0,0,0 26040d: BLKNUM 1 (len=155648), Data=00 00 00 00 00 00 00 00 00 00 00 ... 286411: RECTYPE 1 (len=155668,0x26014 cnt=18) 286419: BLKNUM 0 (len=4), plane=3, uc=0,0,0 286421: BLKNUM 1 (len=155648), Data=00 00 00 00 00 00 00 00 00 00 00 ... 2ac425: RECTYPE 1 (len=155668,0x26014 cnt=19) 2ac42d: BLKNUM 0 (len=4), plane=3, uc=0,0,0 2ac435: BLKNUM 1 (len=155648), Data=00 00 00 00 00 00 00 00 00 00 00 ... 2d2439: RECTYPE 1 (len=155668,0x26014 cnt=20) 2d2441: BLKNUM 0 (len=4), plane=3, uc=0,0,0 2d2449: BLKNUM 1 (len=155648), Data=00 00 00 00 00 00 00 00 00 00 00 ... 2f844d: RECTYPE 1 (len=155668,0x26014 cnt=21) 2f8455: BLKNUM 0 (len=4), plane=3, uc=0,0,0 2f845d: BLKNUM 1 (len=155648), Data=00 00 00 00 00 00 00 00 00 00 00 ... 31e461: RECTYPE 1 (len=155668,0x26014 cnt=22) 31e469: BLKNUM 0 (len=4), plane=3, uc=0,0,0 31e471: BLKNUM 1 (len=155648), Data=00 00 00 00 00 00 00 00 00 00 00 ... 344475: RECTYPE 1 (len=155668,0x26014 cnt=23) 34447d: BLKNUM 0 (len=4), plane=3, uc=0,0,0 344485: BLKNUM 1 (len=155648), Data=00 00 00 00 00 00 00 00 00 00 00 ... 36a489: RECTYPE 1 (len=155668,0x26014 cnt=24) 36a491: BLKNUM 0 (len=4), plane=3, uc=0,0,0 36a499: BLKNUM 1 (len=155648), Data=00 00 00 00 00 00 00 00 00 00 00 ... 39049d: RECTYPE 1 (len=155668,0x26014 cnt=25) 3904a5: BLKNUM 0 (len=4), plane=3, uc=0,0,0 3904ad: BLKNUM 1 (len=155648), Data=00 00 00 00 00 00 00 00 00 00 00 ... 3b64b1: RECTYPE 1 (len=155668,0x26014 cnt=26) 3b64b9: BLKNUM 0 (len=4), plane=3, uc=0,0,0 3b64c1: BLKNUM 1 (len=155648), Data=00 00 00 00 00 00 00 00 00 00 00 ... 3dc4c5: RECTYPE 1 (len=97300,0x17c14 cnt=27) 3dc4cd: BLKNUM 0 (len=4), plane=3, uc=0,0,0 3dc4d5: BLKNUM 1 (len=97280), Data=00 00 00 00 00 00 00 00 00 00 00 ... 3f40d9: RECTYPE 255 (len=8,0x8 cnt=28) 3f40e1: 33%-12345X FILES
/usr/bin/hipercdecode SEE ALSO
foo2hiperc-wrapper(1), foo2hiperc(1) AUTHOR
Rick Richardson <rick.richardson@comcast.net> http://foo2hiperc.rkkda.com/
All times are GMT -4. The time now is 02:30 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy