Sponsored Content
Top Forums Shell Programming and Scripting Find Where Values Change From Positive To Negative and viceversa Post 302506766 by Chubler_XL on Monday 21st of March 2011 11:31:51 PM
Old 03-22-2011
You are correct awk programs consist of any number of <COND> { <statements> } if <COND> is left out or has a value of true for a particular line the statements are executed.

The program I supplied has two of these:

Code:
FNR>1&&$2*prev2<0{print prev1}

if rownumber of input file > 1 and 2nd field multiplied by prev2 < 0 (ie 2nd field and prev2 have different sign) it will print prev1
B.T.W the test on rownumber is unnecessary as prev2 will have null on 1st line and null*value will always be zero (and so not < zero). So removing FNR>1&& would produce the same results.

Code:
$2{prev1=$1;prev2=$2}

if 2nd field is non-zero then prev1=1st fld ; prev2=2nd fld

Last edited by Chubler_XL; 03-22-2011 at 12:59 AM..
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Help in adding positive & negative values in a column

Hi Gurus, In my file I have an amount field from position 74 to 87, which contains values starting with '+' as well as '-'. I want to add all positive values in a varible called "CREDIT" and all negative values in a variable "DEBIT". I know, we can use grep to identify values with positive and... (4 Replies)
Discussion started by: berlin_germany
4 Replies

2. Shell Programming and Scripting

Perl output with negative and positive numbers

Hello, For my weather station I have made a little perl script to put the data into cacti. The next problem I have. I can only get positive numbers or negative numbers. What do I do: Though a shell scrip I call the perl script. Shell script: #!/bin/sh cat data.txt | stats.pl Perl... (4 Replies)
Discussion started by: rbl-blacklight
4 Replies

3. Shell Programming and Scripting

Finding the most positive and negative value and defining its position

Hi, I have a file that looks like this: Jake 2 3 4 6 4 3 -2 -1 Jerry 1 2 3 2 1 7 -6 -1 Timmy -1 -4 -5 -8 9 3 1 I want to find the most positive and negative value for each row and also define its position (based on column #) So the output would look... (7 Replies)
Discussion started by: gisele_l
7 Replies

4. Shell Programming and Scripting

Sorting positive and negative values

Hello, I have a list like this : 1 2 -4 0 -3 -7 5 6 etc. Is there a way to remove all the positive values and print only the negative values, without using grep, sed or awk? Thanks, Prasanna (4 Replies)
Discussion started by: prasanna1157
4 Replies

5. Shell Programming and Scripting

addition of both positive and negative numbers

Let, I have three numbers +00123.25 -00256.54 +00489.23 I need to sum up all those three numbers, after storing them in three variables (say var1, var2, var3). I used both expr and BC, but they didn't work for me. But, I am not able to sum up them, as I don't have any idea how to... (13 Replies)
Discussion started by: mady135
13 Replies

6. Shell Programming and Scripting

Taking largest (negative) number from column of coordinates and adding positive form to every other

Hello all, I'm new to the forums and hope to be able to contribute something useful in the future; however I must admit that what has prompted me to join is the fact that currently I need help with something that has me at the end of my tether. I have a PDB (Protein Data Bank) file which I... (13 Replies)
Discussion started by: crunchgargoyle
13 Replies

7. Shell Programming and Scripting

Splitting a file based on positive and negative numbers

Dear All, I have to split a tab delimited file in two files based on the presence of a positive or negative in column number 9 , for example file: A 1 5 erg + 6766 0.9889 0.9817 9.01882 erg inside upstream B 1 8 erg2 + 6766 0.9889 0.9817 -9.22 erg2 inside... (3 Replies)
Discussion started by: paolo.kunder
3 Replies

8. UNIX for Beginners Questions & Answers

Converting negative number to positive in a file

Hi ALL, I am having semi column separated file as below. I am having negative values for the records starting with 11095. How can I convert that positive number I tried this below seems not working sed 's/ \(*\)$/ -\1/;t;s/\(.*\)-/\1/ myfile myfile... (6 Replies)
Discussion started by: arunkumar_mca
6 Replies

9. UNIX for Beginners Questions & Answers

Splitting a file based on negative and positive numbers

I have a file that is pipe delimited and in Column F they have number values, both positive and negative. I need to take the one file I am starting with and split it into two separate files based on negative and positive numbers. What is the command to do so? And then I need to also transfer... (4 Replies)
Discussion started by: cckaiser15
4 Replies
DtEditorChange(library call)											      DtEditorChange(library call)

NAME
DtEditorChange -- change one or all occurrences of a string in a DtEditor widget SYNOPSIS
#include <Dt/Editor.h> Boolean DtEditorChange( Widget widget, DtEditorChangeValues *findChangeStrings, unsigned int instanceToChange); DESCRIPTION
The DtEditorChange function replaces the next occurrence of a string, all occurrences of the string, or the currently selected text in a DtEditor widget with a replacement string. The string to search for and the value to change it to can be the last values entered in the Find/Change dialog (see DtEditorInvokeFindChangeDialog(3)) or passed as arguments to DtEditorChange. The search begins at the insertion cursor. If the string is not found by the time the end of the document is reached, the search continues at the beginning of the document, stopping at the character before the insertion cursor. The widget argument specifies the DtEditor widget ID. The findChangeStrings argument specifies the string to change and the replacement value. If findChangeStrings is NULL, DtEditorChange uses the last string specified in the Find and Change To fields of the Find/Change dialog. If the instanceToChange argument is DtEDITOR_CUR- RENT_SELECTION, the Find field of DtEditorChangeValues is ignored. If the instanceToChange argument is set to DtEDITOR_NEXT_OCCURRENCE, DtEditorChange replaces the next occurrence (relative to the insertion cursor) of the find string. If this argument is set to DtEDITOR_ALL_OCCURRENCES, all instances of the find string are changed. If this argument ia set to DtEDITOR_CURRENT_SELECTION, the Find field of DtEditorChangeValues, is ignored and the currently selected text is replaced. For a complete definition of the DtEditor widget and its associated resources, see DtEditor(3). For a complete definition of DtEditorChangeValues, see Dt/Editor.h - DtEditor(5). RETURN VALUE
Upon successful completion, the DtEditorChange function returns True if the substitution occurred; otherwise, it returns False. SEE ALSO
Dt/Editor.h - DtEditor(5), DtEditor(3), DtEditorFind(3), DtEditorInvokeFindChangeDialog(3). DtEditorChange(library call)
All times are GMT -4. The time now is 08:21 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy