Help: Find line where column has max vlaue Post: 302372563

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

loop in awk - column max for each column

Hello all, this should really be easy for you... I need AWK to print column maxima for each column of such input: Input: 1 2 3 1 2 1 1 3 2 1 1 2 Output should be: 2 2 3 3 This does the sum, but i need max instead: { for(i=1; i<=NF; i++) sum +=$i } END {for(i=1; i in sum;...

2. UNIX for Dummies Questions & Answers

loop? print max column in each line for 800 files and merge

Hello, I have 800 or so files with 3 columns each and >10000 lines each. For each file and each line I would like to print the maximum column number for each line. Then I would like to 'paste' each of these files together (column-wise) so that the file with expression in label '_1' is the...

3. Shell Programming and Scripting

Find in first column and replace the line with Awk, and output new file

Find in first column and replace the line with Awk, and output new file File1.txt"2011-11-02","Georgia","Atlanta","x","","" "2011-11-03","California","Los Angeles","x","","" "2011-11-04","Georgia","Atlanta","x","x","x" "2011-11-05","Georgia","Atlanta","x","x","" ...

4. Shell Programming and Scripting

to find min and max value for each column!

Hello Experts, I have got a txt files which has multiple columns, I want to get the max, min and diff (max-min) for each column in the same txt file. Example: cat file.txt a 1 4 b 2 5 c 3 6 I want ouput like: cat file.txt a 1 4 b 2 5 c 3 6 Max 3 6 Min 1 4 Diff 2 2 awk 'min=="" ||...

5. Shell Programming and Scripting

AWK script to create max value of 3rd column, grouping by first column

Hi, I need an awk script (or whatever shell-construct) that would take data like below and get the max value of 3 column, when grouping by the 1st column. clientname,day-of-month,max-users ----------------------------------- client1,20120610,5 client2,20120610,2 client3,20120610,7...

6. UNIX for Dummies Questions & Answers

get max value every 4 rows between 2 column

Hi all I have a file that has two columns and I need the maximum value in column 2 of 4 positions o rows. for example at position {1..3} there are 4 characters (A, C, G and T) each of these characters with a value with a value in column 2. I need the maximum value in column 2 and the corresponding...

7. Shell Programming and Scripting

Get the MAX value out of a column

I've the following data set. I would like to look at the column 3 and only use the rows which has the max value for column 3 Can we use the awk or sed to achieve it. 10 2 10 100 11 2 20 100 12 2 30 100 13 2 30 100 14 ...

8. UNIX for Dummies Questions & Answers

Using awk to find max and printing entire line

Hi folks, I am very new to awk. I have what is probably a very simple question. I'm trying to get the max value of column 1, but also print column 2. My data looks like this: 0.044|2000-02-03 14:00:00 5.23|2000-02-03 05:45:00 5.26|2000-02-03 11:15:00 0|2000-02-01 18:30:00 So in this case...

9. Shell Programming and Scripting

Get min and max value in column

Gents, I have a big file file like this. 5100010002 5100010004 5100010006 5100010008 5100010010 5100010012 5102010002 5102010004 5102010006 5102010008 5102010010 5102010012 The file is sorted and I would like to find the min and max value, taking in the consideration key1...

10. Shell Programming and Scripting

Find Max value of line and print

I need to find the max value of all columns except the 1st column and print the answer along with the 1st column. Input 123xyz 0 0 1 2 0 0 0 0 0 0 0 234xyz 0 0 0 0 0 0 0 0 0 0 0 345xyz 0 0 1 0 0 0 ...

LEARN ABOUT DEBIAN

grdcut

GRDCUT(l)																 GRDCUT(l)

NAME

       grdcut - Extract a subregion out of a .grd file

SYNOPSIS

       grdcut input_file.grd -Goutput_file.grd -Rwest/east/south/north[r] [ -V ]

DESCRIPTION

       grdcut	will   produce	 a  new  output_file.grd  file	which  is  a  subregion  of  input_file.grd.   The  subregion  is  specified  with
       -Rwest/east/south/north as in other programs; the specified range must not exceed the range of input_file.grd. If in doubt, run grdinfo	to
       check range. Complementary to grdcut there is grdpaste, which will join together two grdfiles along a common edge.

       input_file.grd
	      this is the input .grd format file.

       -Goutput_file.grd
	      this is the output .grd format file.

       -R     west,  east,  south,  and  north specify the Region of interest. To specify boundaries in degrees and minutes [and seconds], use the
	      dd:mm[:ss] format. Append r if lower left and upper right map coordinates are given instead of wesn.  This defines the subregion	to
	      be cut out.

OPTIONS

       -V     Selects verbose mode, which will send progress reports to stderr [Default runs "silently"].

EXAMPLES

       Suppose	you  have used surface to grid ship gravity in the region between 148E - 162E and 8N - 32N, and you do not trust the gridding near
       the edges, so you want to keep only the area between 150E - 160E and 10N - 30N, then:

       grdcut grav_148_162_8_32.grd -Ggrav_150_160_10_30.grd -R150/160/10/30 -V

SEE ALSO

       grdpaste(1gmt), grdinfo(1gmt), gmt(1gmt)

								    1 Jan 2004								 GRDCUT(l)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

loop in awk - column max for each column

Discussion started by: irrevocabile

2. UNIX for Dummies Questions & Answers

loop? print max column in each line for 800 files and merge

Discussion started by: peanuts48

3. Shell Programming and Scripting

Find in first column and replace the line with Awk, and output new file

Discussion started by: charles33

4. Shell Programming and Scripting

to find min and max value for each column!

Discussion started by: dixits