awk to select rows based on condition on column Post: 302368007

10 More Discussions You Might Find Interesting

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

2. Shell Programming and Scripting

Select rows where the 3rd column value is over xx

Hi All, I've got a text file which is Postcode,Postcode, Travel_time and I want to select all of the rows where the 3rd column value is over 255. Can someone show me the magic on how to do this? Originally it did contain 4 columns but i've managed to strip out the first 3 using: cat textfile |...

3. Shell Programming and Scripting

Combining multiple rows in single row based on certain condition using awk or sed

Hi, I'm using AIX(ksh shell). > cat temp.txt "a","b",0 "c",bc",0 "a1","b1",0 "cc","cb",1 "cc","b2",1 "bb","bc",2 I want the output as: "a","b","c","bc","a1","b1" "cc","cb","cc","b2" "bb","bc" I want to combine multiple lines into single line where third column is same. Is...

4. UNIX for Dummies Questions & Answers

merging rows into new file based on rows and first column

I have 2 files, file01= 7 columns, row unknown (but few) file02= 7 columns, row unknown (but many) now I want to create an output with the first field that is shared in both of them and then subtract the results from the rest of the fields and print there e.g. file 01 James|0|50|25|10|50|30...

5. Shell Programming and Scripting

Select distinct rows in a file by last column

Hi, I have the following file: LOG:015608::ERR:2310:map_spsrec:Invalid parameter LOG:015608::ERR:2471:map_dgdrec:Invalid parameter LOG:015608::ERR:2487:map_nnmrec:Invalid number LOG:015608::ERR:2310:map_nmrec:Invalid number LOG:015608::ERR:2438:map_nmrec:Invalid number As a delimiter I...

6. Shell Programming and Scripting

Need to select some column from file1 if condition match.

I have two files file1.txt and file2.txt. want to print some column(number,status,date1,date2,description(descrption column end before category column start with'Oracle Services') and assigned_to column from file1.txt ...If the assigned_to name in file2.txt matches with assinged_to name in...

7. Shell Programming and Scripting

Convert rows to columns based on condition

I have a file some thing like this: GN Name=YWHAB; RC TISSUE=Keratinocyte; RC TISSUE=Thymus; CC -!- FUNCTION: Adapter protein implicated in the regulation of a large CC spectrum of both general and specialized signaling pathways GN Name=YWHAE; RC TISSUE=Liver; RC ...

8. Shell Programming and Scripting

awk to ignore multiple rows based on a condition

All, I have a text file(Inputfile.csv) with millions of rows and 100 columns. Check the sample for 2 columns below. Key,Check A,1 A,2 A, A,4 B,0 B,1 B,2 B,3 B,4 .... million rows. My requirement is to delete all the rows corresponding to all the keys which ever has at least one...

9. UNIX for Advanced & Expert Users

Conversion of rows to columns using awk based om column value

HI, My Input file data is dn:adcfgeneral id:13343 Name:xxxxxx Password:iutyerwuitywue wpuwt tuiytruityrutyrwtyrwp dn:cdferwjyyyy id:3875 Name:yyyy Password :hgfdsjkfhdsfkdlshf dshfkldshfdklsfh interset:uiuiufj My output should be ...

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

LEARN ABOUT CENTOS

dblink_get_result

DBLINK_GET_RESULT(3)					  PostgreSQL 9.2.7 Documentation				      DBLINK_GET_RESULT(3)

NAME

       dblink_get_result - gets an async query result

SYNOPSIS

       dblink_get_result(text connname [, bool fail_on_error]) returns setof record

DESCRIPTION

       dblink_get_result collects the results of an asynchronous query previously sent with dblink_send_query. If the query is not already
       completed, dblink_get_result will wait until it is.

ARGUMENTS

       conname
	   Name of the connection to use.

       fail_on_error
	   If true (the default when omitted) then an error thrown on the remote side of the connection causes an error to also be thrown locally.
	   If false, the remote error is locally reported as a NOTICE, and the function returns no rows.

RETURN VALUE

       For an async query (that is, a SQL statement returning rows), the function returns the row(s) produced by the query. To use this function,
       you will need to specify the expected set of columns, as previously discussed for dblink.

       For an async command (that is, a SQL statement not returning rows), the function returns a single row with a single text column containing
       the command's status string. It is still necessary to specify that the result will have a single text column in the calling FROM clause.

NOTES

       This function must be called if dblink_send_query returned 1. It must be called once for each query sent, and one additional time to obtain
       an empty set result, before the connection can be used again.

       When using dblink_send_query and dblink_get_result, dblink fetches the entire remote query result before returning any of it to the local
       query processor. If the query returns a large number of rows, this can result in transient memory bloat in the local session. It may be
       better to open such a query as a cursor with dblink_open and then fetch a manageable number of rows at a time. Alternatively, use plain
       dblink(), which avoids memory bloat by spooling large result sets to disk.

EXAMPLES

	   contrib_regression=# SELECT dblink_connect('dtest1', 'dbname=contrib_regression');
	    dblink_connect
	   ----------------
	    OK
	   (1 row)

	   contrib_regression=# SELECT * FROM
	   contrib_regression-# dblink_send_query('dtest1', 'select * from foo where f1 < 3') AS t1;
	    t1
	   ----
	     1
	   (1 row)

	   contrib_regression=# SELECT * FROM dblink_get_result('dtest1') AS t1(f1 int, f2 text, f3 text[]);
	    f1 | f2 |	  f3
	   ----+----+------------
	     0 | a  | {a0,b0,c0}
	     1 | b  | {a1,b1,c1}
	     2 | c  | {a2,b2,c2}
	   (3 rows)

	   contrib_regression=# SELECT * FROM dblink_get_result('dtest1') AS t1(f1 int, f2 text, f3 text[]);
	    f1 | f2 | f3
	   ----+----+----
	   (0 rows)

	   contrib_regression=# SELECT * FROM
	   contrib_regression-# dblink_send_query('dtest1', 'select * from foo where f1 < 3; select * from foo where f1 > 6') AS t1;
	    t1
	   ----
	     1
	   (1 row)

	   contrib_regression=# SELECT * FROM dblink_get_result('dtest1') AS t1(f1 int, f2 text, f3 text[]);
	    f1 | f2 |	  f3
	   ----+----+------------
	     0 | a  | {a0,b0,c0}
	     1 | b  | {a1,b1,c1}
	     2 | c  | {a2,b2,c2}
	   (3 rows)

	   contrib_regression=# SELECT * FROM dblink_get_result('dtest1') AS t1(f1 int, f2 text, f3 text[]);
	    f1 | f2 |	   f3
	   ----+----+---------------
	     7 | h  | {a7,b7,c7}
	     8 | i  | {a8,b8,c8}
	     9 | j  | {a9,b9,c9}
	    10 | k  | {a10,b10,c10}
	   (4 rows)

	   contrib_regression=# SELECT * FROM dblink_get_result('dtest1') AS t1(f1 int, f2 text, f3 text[]);
	    f1 | f2 | f3
	   ----+----+----
	   (0 rows)

PostgreSQL 9.2.7						    2014-02-17						      DBLINK_GET_RESULT(3)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

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

Discussion started by: Gizmo1007

2. Shell Programming and Scripting

Select rows where the 3rd column value is over xx

Discussion started by: gman

3. Shell Programming and Scripting

Combining multiple rows in single row based on certain condition using awk or sed

Discussion started by: samuelray

4. UNIX for Dummies Questions & Answers

merging rows into new file based on rows and first column

Discussion started by: A-V