How to get min and max values using awk? Post: 302911860

Sponsored Content

Top Forums Shell Programming and Scripting How to get min and max values using awk? Post 302911860 by RudiC on Monday 4th of August 2014 06:39:35 AM

08-04-2014

Registered User

Answers to Don Cragun's above question may kill the assumptions on which this is based. Try

Code:

awk     '$2 != "CD"     {next}                                          # not a "CD" line -> no action
         !($7 in LINE)  {LINE[$7]=$0}                                   # new $7? Keep line with first occurrence of $3/$4 in memory
                        {CNT[$7]++; E3[$7]=$3; E4[$7]=$4}               # count $7 lines and keep last $3 and $4

         END            {for (i in LINE) if (CNT[i]>=2) {               # for the lines recorded, if count = 1: discard
                                 match (LINE[i],"[0-9]*\t[0-9]*\t[+-]") # search for $3 $4 +- pattern (you can use constants here if 
                                                                        # sure the file structure remains identical all over)
                                 if (substr (LINE[i], RSTART+RLENGTH-1, 1) == "-") {    # take decision on + or -
                                        POS=RSTART                      # where to replace
                                        STR=E3[i]}                      # what to put in 
                                  else {POS=RSTART+8
                                        STR=E4[i]} 
                                 print  substr (LINE[i], 1, POS-2),     # print first part of line, dep. on sign
                                        STR,                            #       replacement string
                                        substr (LINE[i], POS+8)         #       last part
                                }
                        }
        ' FS="\t" OFS="\t" file
SP12.3    CD    2249762    2252075    -    ID1_N006     ID2_N006T1
SP12.5    CD    3001307    3005025    +    ID1_N01140    ID2_N01140T0
SP12.3    CD    2249762    2253117    -    ID1_N006     ID2_N006T0
SP12.3    CD    2240806    2241681    +    ID1_N003     ID2_N003T0

This User Gave Thanks to RudiC For This Post:

RudiC

View Public Profile for RudiC

Find all posts by RudiC

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

max values amd min values

Hello every one, I have following data ***CAMPAIGN 1998 CONTRIBUTIONS*** --------------------------------------------------------------------------- NAME PHONE Jan | Feb | Mar | Total Donated ...

2. UNIX for Dummies Questions & Answers

Awk search for max and min field values

hi, i have an awk script and I managed to figure out how to search the max value but Im having difficulty in searching for the min field value. BEGIN {FS=","; max=0} NF == 7 {if (max < $6) max = $6;} END { print man, min} where $6 is the column of a field separated by a comma

3. Shell Programming and Scripting

Find min.max value if matching columns found using AWK

Input_ File : 2 3 4 5 1 1 0 1 2 1 -1 1 2 1 3 1 3 1 4 1 6 5 6 6 6 6 6 7 6 7 6 8 5 8 6 7 Desired output : 2 3 4 5 -1 1 4 1 6 5 6 8 5 8 6 7

4. Shell Programming and Scripting

AWK script - extracting min and max values from selected lines

Hi guys! I'm new to scripting and I need to write a script in awk. Here is example of file on which I'm working ATOM 4688 HG1 PRO A 322 18.080 59.680 137.020 1.00 0.00 ATOM 4689 HG2 PRO A 322 18.850 61.220 137.010 1.00 0.00 ATOM 4690 CD ...

5. UNIX for Dummies Questions & Answers

[Solved] Print a line using a max and a min values of different columns

Hi guys, I already search on the forum but i can't solve this on my own. I have a lot of files like this: And i need to print the line with the maximum value in last column but if the value is the same (2 in this exemple for the 3 last lines) i need get the line with the minimum value in...

6. Shell Programming and Scripting

Average, min and max in file with header, using awk

Hi, I have a file which looks like this: FID IID MISS_PHENO N_MISS N_GENO F_MISS 12AB43131 12AB43131 N 17774 906341 0.01961 65HJ87451 65HJ87451 N 10149 906341 0.0112 43JJ21345 43JJ21345 N 2826 906341 0.003118I would...

7. Shell Programming and Scripting

Get the min avg and max with awk

aaa: 3 ms aaa: 2 ms aaa: 5 ms aaa: 10 ms .......... to get the 3 2 5 10 ...'s min avg and max something like min: 2 ms avg: 5 ms max: 10 ms

8. Shell Programming and Scripting

awk script to find min and max value

I need to find the max/min of columns 1 and 2 of a 2 column file what contains the special character ">". I know that this will find the max value of column 1. awk 'BEGIN {max = 0} {if ($1>max) max=$1} END {print max}' input.file But what if I needed to ignore special characters in the...

9. Shell Programming and Scripting

awk search for max and min while ignoring special character

I am trying to get a simple min/max script to work with the below input. Note the special character (">") within it. Script awk 'BEGIN{max=0}{if(($1)>max) max=($1)}END {print max}' awk 'BEGIN{min=0}{if(($2)<min) min=($2)}END {print min}' Input -122.2840 42.0009 -119.9950 ...

10. Shell Programming and Scripting

awk Sort 2d histogram output from min(X,Y) to max(X,Y)

I've got Gnuplot-format 2D histogram data output which looks as follows. 6.5 -1.25 10.2804 6.5404 -1.25 10.4907 6.58081 -1.25 10.8087 6.62121 -1.25 10.4686 6.66162 -1.25 10.506 6.70202 -1.25 10.3084 6.74242 -1.25 9.68256 6.78283 -1.25 9.41229 6.82323 -1.25 9.43078 6.86364 -1.25 9.62408...

LEARN ABOUT OPENSOLARIS

rnano

RNANO(1)						      General Commands Manual							  RNANO(1)

NAME

       rnano - Restricted mode for Nano's ANOther editor, an enhanced free Pico clone

SYNOPSIS

       rnano [OPTIONS] [[+LINE,COLUMN] FILE]...

DESCRIPTION

       This manual page briefly documents the rnano command.

       nano is a small, free and friendly editor which aims to replace Pico, the default editor included in the non-free Pine package. Rather than
       just copying Pico's look and feel, nano also implements some missing (or disabled by  default)  features  in  Pico,  such  as  "search  and
       replace" and "go to line and column number".

       rnano  is  a  restricted  version of nano, which only edits specific files and doesn't allow the user access to the filesystem or a command
       shell.

       In restricted mode, nano will not:

       o read or write to any file not specified on the command line;

       o read any nanorc files;

       o allow suspending;

       o allow a file to be appended to, prepended to, or saved under a different name;

       o use backup files or spell checking.

OPTIONS

       +LINE,COLUMN
	      Places cursor at line number LINE and column number COLUMN (at least one of which must be specified)  on	startup,  instead  of  the
	      default of line 1, column 1.

       -?     Same as -h (--help).

       -h (--help)
	      Show a summary of command line options and exit.

       -V (--version)
	      Show the current version number and exit.

       See the nano(1) manpage for the complete documentation of nano.

BUGS

       Please send any comments or bug reports to nano@nano-editor.org.

       The nano mailing list is available from nano-devel@gnu.org.

       To subscribe, email to nano-devel-request@gnu.org with a subject of "subscribe".

HOMEPAGE

       http://www.nano-editor.org/

AUTHOR

       Chris  Allegretta  <chrisa@asty.org>,  et  al  (see  AUTHORS  for  details).   This  manual  page was originally written by Thijs Kinkhorst
       <thijs@kinkhorst.com>, for the Debian system (but may be used by others).

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +--------------------+-----------------+
       |  ATTRIBUTE TYPE    | ATTRIBUTE VALUE |
       +--------------------+-----------------+
       |Availability	    | SUNWgnu-nano    |
       +--------------------+-----------------+
       |Interface Stability | Uncommitted     |
       +--------------------+-----------------+
NOTES

       Source for GNU nano is available on http://opensolaris.org.

August 23, 2007 						   version 2.0.0							  RNANO(1)