How to capture 2 consecutive rows when a condition is true ? Post: 302138663

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

how to capture no. of rows updated in update sql in unix db2

hi, i am a new user in unix..and we have unix db2. i want to capture the no. of rows updated by a update db2 sql statement and redirect into a log file. I've seen db2 -m...but not sure how the syntax should be. The update sql that I'm going to run is from a file... Can you please share...

2. Shell Programming and Scripting

remove consecutive duplicate rows

I have some data that looks like, 1 3300665.mol 3300665 5177008 102.093 2 3300665.mol 3300665 5177008 102.093 3 3294015.mol 3294015 5131552 102.114 4 3294015.mol 3294015 5131552 102.114 5 3293734.mol 3293734 5129625 104.152 6 3293734.mol ...

3. Shell Programming and Scripting

Print merged rows from two files by applying if condition

Hi all, I have list of two kind of files and I want to compare the rows and print the merged data by applying if condition. First kind of file looks like: and second kind of file looks like : I want to print the rows present in second file followed by 3 more columns from first...

4. Shell Programming and Scripting

deleting rows under a certain condition

there are 20 variables and I would like to delete the rows if 13th-20th columns are all NA. Thank you! FID IID aspirpre statihos fibrahos ocholhos arbhos betabhos alphbhos cacbhos diurehos numbcig.x toast1 toast2 toast3 toast4 ischoth1 ischoth2 ischoth3 ischoth4 101 101 1 1 1 1 1 2 1 2...

5. Shell Programming and Scripting

Capture rows for a column in file from delete sql -Oracle

Hi, This may not be the right forum but i am hoping someone knows an answer to this. I have to capture rows for a column that was deleted. How can i do that without having to write a select query? delete from myschema.mytable where currentdatetimestamp > columnDate this should delete 5...

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

7. Shell Programming and Scripting

Columns to Rows - Transpose - Special Condition

Hi Friends, Hope all is well. I have an input file like this a gene1 10 b gene1 2 c gene2 20 c gene3 10 d gene4 5 e gene5 6 Steps to reach output. 1. Print unique values of column1 as column of the matrix, which will be a b c

8. Shell Programming and Scripting

Average across rows with a condition

Hi Friends, My input file Gene1 10 20 0 Gene2 5 0 15 Gene3 10 10 10 Gene4 5 0 0 If there is a zero for any gene in any column, I don't want that column to be considered which reduces the denominator value during average. Here is my output Gene1 10 20 0 10 Gene2 5 0 15 10 Gene3...

9. Shell Programming and Scripting

Compute value from more than three consecutive rows

Hello all, I am working on a file like below: site Date time value1 value2 0023 2014-01-01 00:00 32.0 23.7 0023 2014-01-01 01:00 38.0 29.9 0023 2014-01-01 02:00 85.0 26.6 0023 2014-01-01 03:00 34.0 25.3 0023 2014-01-01 04:00 37.0 23.8 0023 2014-01-01 05:00 80.0 20.3 0023 2014-01-01 06:00...

10. Shell Programming and Scripting

awk to capture lines that meet either condition

I am trying to modify and understand an awk written by @Scrutinizer The below awk will filter a list of 30,000 lines in the tab-delimited file. What I am having trouble with is adding a condition to SVTYPE=CNV that will only print that line if CI=,0.95: portion in blue in file is <1.9. The...

LEARN ABOUT SUSE

purple

Purple(3)						User Contributed Perl Documentation						 Purple(3)

NAME

       Purple - Perl extension to the libpurple instant messenger library.

SYNOPSIS

	 use Purple;

ABSTRACT

	 This module provides the interface for using perl scripts as plugins
	 in libpurple.

DESCRIPTION

       This module provides the interface for using perl scripts as plugins in Purple. With this, developers can write perl scripts that can be
       loaded in Purple as plugins. The scripts can interact with IMs, chats, accounts, the buddy list, libpurple signals, and more.

       The API for the perl interface is very similar to that of the Purple C API, which can be viewed at http://developer.pidgin.im/doxygen/ or
       in the header files in the Purple source tree.

FUNCTIONS

       @accounts = Purple::accounts
	   Returns a list of all accounts, online or offline.

       @chats = Purple::chats
	   Returns a list of all chats currently open.

       @connections = Purple::connections
	   Returns a list of all active connections.

       @conversations = Purple::conversations
	   Returns a list of all conversations, both IM and chat, currently open.

       @conv_windows = Purple::conv_windows
	   Returns a list of all conversation windows currently open.

       @ims = Purple::ims
	   Returns a list of all instant messages currently open.

SEE ALSO

       Purple C API documentation - http://developer.pidgin.im/doxygen/

       Purple website - http://pidgin.im/

AUTHOR

       Christian Hammond, <chipx86@gnupdate.org>

COPYRIGHT AND LICENSE

       Copyright 2003 by Christian Hammond

       This library is free software; you can redistribute it and/or modify it under the terms of the General Public License (GPL).  For more
       information, see http://www.fsf.org/licenses/gpl.txt

perl v5.12.1							    2010-02-16								 Purple(3)