Select Record based on First Column Post: 302126727

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Select records based on search criteria on first column

Hi All, I need to select only those records having a non zero record in the first column of a comma delimited file. Suppose my input file is having data like: "0","01/08/2005 07:11:15",1,1,"Created",,"01/08/2005" "0","01/08/2005 07:12:40",1,1,"Created",,"01/08/2005"...

2. Shell Programming and Scripting

awk to select rows based on condition on column

I have got a file like this 003ABC00281020091005000100042.810001 ...

3. Shell Programming and Scripting

Select record with MAX value in MySQL

Hi there, I have trouble selecting record that contain one biggest value for a group of other values. I mean, this is my table: mysql> SELECT * FROM b; +----+------+-------+ | id | user | value | +----+------+-------+ | 1 | 1 | 100 | | 3 | 1 | 150 | | 5 | 1 | 300 | | 6...

4. Shell Programming and Scripting

Awk - how to select the column based on day of month

Problem, How can you pass today's date (eg) 18 into Awk and select the field representing the 18th column? I have an output that I want to interact with based on what day it is information=0:0 192:0 5436:0 22:99 0:0 0:0 1234:0 1359:09 DAY=date'+%d' numbrs=`$information | awk...

5. Shell Programming and Scripting

Select only top "N" records based on column value

Hi Gurus, I know this'll be simple task for all the geeks out here but me being a newbie is finding it hard to crack this shell. Ok coming to the task I've a delimited file as below ================================================== ==================================================== ...

6. Shell Programming and Scripting

Select record having different value in second column

I want records which have more than one and different value in the second column on the below sample file. Ex, I have the samle file below :- XYZ 1 XYZ 3 abc 1 abc 1 qwe 2 qwe 1 qwe 3 I want to select XYZ and QWE line only.

7. UNIX for Dummies Questions & Answers

Match sum of values in each column with the corresponding column value present in trailer record

Hi All, I have a requirement where I need to find sum of values from column D through O present in a CSV file and check whether the sum of each Individual column matches with the value present for that corresponding column present in the trailer record. For example, let's assume for column D...

8. Shell Programming and Scripting

awk to select lines with maximum value of each record based on column value

Hello, I want to get the maximum value of each record separated by empty line based on the 3rd column of each row within each record? Input: A1 chr5D 634 7 82 707 A2 chr5D 637 6 82 713 A3 chr5D 637 5 82 713 A4 chr5D 626 1 82 704...

9. UNIX for Beginners Questions & Answers

Select and copy .csv files based on row and column number

Dear UNIX experts, I'm a command line novice working on a Macintosh computer (Bash shell) and have neither found advice that is pertinent to my problem on the internet nor in this forum. I have hundreds of .csv files in a directory. Now I would like to copy the subset of files that contains...

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)