Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: awk second largest, third largest value
Top Forums Shell Programming and Scripting awk second largest, third largest value Post 302555062 by sk1418 on Tuesday 13th of September 2011 06:08:49 PM
Old 09-13-2011
assumed that you have sorted the file. based on your example data:
Code:
kent$  echo "133 800         
133 799
133 798
133 403
133 402
133 401"|awk 'NR==1{max=$2;next;}max-$2>5{print $0;exit;}'

133 403

if you want to put the line into a new file:

awk 'NR==1{max=$2;next;}max-$2>5{print $0 >> "2ndLargest.txt";exit;}' inputFile

This User Gave Thanks to sk1418 For This Post:
theawknewbie
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

find largest file

Hi, 1)I have XX directory and have lot of files ,I want to find largest file in that directory 2)how calculate the size of file in MB. Thanks, Mohan (15 Replies)
Discussion started by: mohan705
15 Replies

2. Shell Programming and Scripting

largest value from within a file

hi, i am having a file that looks like this : myhome111 oper 11 myhome333 oper 19 ... how can i get the largest value from this file ..in this example i am consiering 19 as the largest value.. how can i do that.. as this file is having other numbers also within it like 111, 333... (4 Replies)
Discussion started by: kripssmart
4 Replies

3. Shell Programming and Scripting

largest field , awk , help

Hi All, My file is like this: $ cat max.txt abcd:1982:a efghij:1980:e klmn:1923:k opqrst:1982:o I have to find out the largest first field and the corresponding line. i.e Output required: efghij efghij:1980:e opqrst opqrst:1982:o HTH, jkl_jkl (6 Replies)
Discussion started by: jkl_jkl
6 Replies

4. Shell Programming and Scripting

Find largest files

Hello, i am on linux 2.6.13-1.1526_FC4smp , and i would be very greatfull if someone could help to find the largest files on that server. I know i can find files with find command or list them with ls , but is there a way that i could list let's say 10 biggest files on server ? :o (11 Replies)
Discussion started by: tonijel
11 Replies

5. UNIX for Dummies Questions & Answers

largest file

My directory only contains files..no sub directories..I want to know about the largest file in directory..Largest in terms of size..And what if I want to know about first 3 largest files.. Is it possible to know largest file in terms of its filename?? (4 Replies)
Discussion started by: aadi_uni
4 Replies

6. Shell Programming and Scripting

AWK (how) to get smallest/largest nr of ls -la

Hey, This is a long-shot however, I am stuck with the following problem: I have the output from ls -la, and I want to sort some of that data out by using AWK to filter it. ls -la | awk -f scriptname.awk Input: For example: drwxr-xr-x 3 user users 4096 2010-03-14 20:15 bin/... (5 Replies)
Discussion started by: abciscool
5 Replies

7. Shell Programming and Scripting

Help with keep the largest record in file

Input file US Score 10 UK Ball 20 AS Score 50 AK Ball 10 PZ Ballon 50 PA Score 70 WT Data 10 . . Desired output file UK Ball 20 PZ Ballon 50 PA Score 70 WT Data 10 . . (1 Reply)
Discussion started by: perl_beginner
1 Replies

8. UNIX for Dummies Questions & Answers

Printf awk: argument to adjust automatically width to the largest value

Hi ! Here is an example of a tab-delimited file with variable width values in field 2 (space separated values). As the real file contains lot of lines, I can adjust manually the width to the largest value in field 2. Does it exist an argument to do it automatically? input.tab:... (4 Replies)
Discussion started by: lucasvs
4 Replies

9. Shell Programming and Scripting

Largest number in array. Help!

I need to calculate the biggest number in array size n. Example: Users enter: 1 7 4 9 The biggest number is : 9 Simple but I'm really new on this on Shell/Bash! Anything will be helpful! Thanks! #!/bin/bash printf "\tEnter a list of numbers, with spaces: " read -a ARRAY BIG=$1... (5 Replies)
Discussion started by: Sundown
5 Replies

10. Shell Programming and Scripting

awk to combine all matching fields in input but only print line with largest value in specific field

In the below I am trying to use awk to match all the $13 values in input, which is tab-delimited, that are in $1 of gene which is just a single column of text. However only the line with the greatest $9 value in input needs to be printed. So in the example below all the MECP2 and LTBP1... (0 Replies)
Discussion started by: cmccabe
0 Replies

LEARN ABOUT SUNOS

iconv_646

iconv_646(5)						Standards, Environments, and Macros					      iconv_646(5)

NAME

       iconv_646 - code set conversion tables for ISO 646

DESCRIPTION

       The following code set conversions are supported:

       +-----------------------------------------------------------------------+
       |		    Code Set Conversions Supported		       |
       +----------+---------------+--------------+--------+--------------------+
       |  Code	  |    Symbol	  |Target Code	 |Symbol  |   Target Output    |
       +----------+---------------+--------------+--------+--------------------+
       |ISO 646   | 646 	  |ISO 8859-1	 |8859	  |US ASCII	       |
       +----------+---------------+--------------+--------+--------------------+
       |ISO 646de | 646de	  |ISO 8859-1	 |8859	  |German	       |
       +----------+---------------+--------------+--------+--------------------+
       |ISO 646da | 646da	  |ISO 8859-1	 |8859	  |Danish	       |
       +----------+---------------+--------------+--------+--------------------+
       |ISO 646en | 646en	  |ISO 8859-1	 |8859	  |English ASCII       |
       +----------+---------------+--------------+--------+--------------------+
       |ISO 646es | 646es	  |ISO 8859-1	 |8859	  |Spanish	       |
       +----------+---------------+--------------+--------+--------------------+
       |ISO 646fr | 646fr	  |ISO 8859-1	 |8859	  |French	       |
       +----------+---------------+--------------+--------+--------------------+
       |ISO 646it | 646it	  |ISO 8859-1	 |8859	  |Italian	       |
       +----------+---------------+--------------+--------+--------------------+
       |ISO 646sv | 646sv	  |ISO 8859-1	 |8859	  |Swedish	       |
       +----------+---------------+--------------+--------+--------------------+

CONVERSIONS

       The conversions are performed according to the following tables. All values in the tables are given in octal.

   ISO 646 (US ASCII) to ISO 8859-1
       For the conversion of ISO 646 to ISO 8859-1, all characters in ISO 646 can be mapped unchanged to ISO 8859-1

   ISO 646de (GERMAN) to ISO 8859-1
       For the conversion of ISO 646de to ISO 8859-1, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |  ISO 646de    |  ISO 8859-1	|  ISO 646de	 |  ISO 8859-1	 |
       |100	       | 247		|173		 |344		 |
       |133	       | 304		|174		 |366		 |
       |134	       | 326		|175		 |374		 |
       |135	       | 334		|176		 |337		 |
       +---------------+----------------+----------------+---------------+

   ISO 646da (DANISH) to ISO 8859-1
       For the conversion of ISO 646da	to ISO 8859-1, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |  ISO 646da    |  ISO 8859-1	|  ISO 646da	 |  ISO 8859-1	 |
       |133	       | 306		|173		 |346		 |
       |134	       | 330		|174		 |370		 |
       |135	       | 305		|175		 |345		 |
       +---------------+----------------+----------------+---------------+

   ISO 646en (ENGLISH ASCII) to ISO 8859-1
       For the conversion of ISO 646en to ISO 8859-1, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------+
       |		  Conversions|Performed 		   |
       |	 ISO 646en	     |	       ISO 8859-1	   |
       |043			     |243			   |
       +-----------------------------+-----------------------------+

   ISO 646es (SPANISH) to ISO 8859-1
       For the conversion of ISO 646es to ISO 8859-1, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |  ISO 646es    |  ISO 8859-1	|  ISO 646es	 |  ISO 8859-1	 |
       |100	       | 247		|173		 |260		 |
       |133	       | 241		|174		 |361		 |
       |134	       | 321		|175		 |347		 |
       |135	       | 277		|		 |		 |
       +---------------+----------------+----------------+---------------+

   ISO 646fr (FRENCH) to ISO 8859-1
       For the conversion of ISO 646fr to ISO 8859-1, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |  ISO 646fr    |  ISO 8859-1	|  ISO 646fr	 |  ISO 8859-1	 |
       |043	       | 243		|173		 |351		 |
       |100	       | 340		|174		 |371		 |
       |133	       | 260		|175		 |350		 |
       |134	       | 347		|176		 |250		 |
       |135	       | 247		|		 |		 |
       +---------------+----------------+----------------+---------------+

   ISO 646it (ITALIAN) to ISO 8859-1
       For the conversion of ISO 646it to ISO 8859-1, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |  ISO 646it    |  ISO 8859-1	|  ISO 646it	 |  ISO 8859-1	 |
       |043	       | 243		|140		 |371		 |
       |100	       | 247		|173		 |340		 |
       |133	       | 260		|174		 |362		 |
       |134	       | 347		|175		 |350		 |
       |135	       | 351		|176		 |354		 |
       +---------------+----------------+----------------+---------------+

   ISO 646sv (SWEDISH) to ISO 8859-1
       For the conversion of ISO 646sv to ISO 8859-1, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |  ISO 646sv    |  ISO 8859-1	|  ISO 646sv	 |  ISO 8859-1	 |
       |100	       | 311		|140		 |351		 |
       |133	       | 304		|173		 |344		 |
       |134	       | 326		|174		 |366		 |
       |135	       | 305		|175		 |345		 |
       |136	       | 334		|176		 |374		 |
       +---------------+----------------+----------------+---------------+

FILES

       /usr/lib/iconv/*.so	       conversion modules

       /usr/lib/iconv/*.t	       conversion tables

       /usr/lib/iconv/iconv_data       list of conversions supported by conversion tables

SEE ALSO

       iconv(1), iconv(3C), iconv(5)

SunOS 5.10							    28 Apr 1997 						      iconv_646(5)
All times are GMT -4. The time now is 05:48 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy