## Conavert negative values to Zeros

Conavert negative values to Zeros
# 1
08-26-2014
Conavert negative values to Zeros

Please find the attached input and output file for ur reference.

a)Incase if i get negative value (ex:-000100) in the 11th column then i have to convert the value to 0000000(7 zeros-length is 7) and then
print the entire record.
b)Incase if there is no negative value present in the 11th column , then print all records as it is.
 vinus View Public Profile for vinus Find all posts by vinus
# 2
08-26-2014
This User Gave Thanks to Corona688 For This Post:
 Corona688 View Public Profile for Corona688 Visit Corona688's homepage! Find all posts by Corona688
# 3
08-26-2014
 Corona688 View Public Profile for Corona688 Visit Corona688's homepage! Find all posts by Corona688

## How to sum the value with negative values?

Hi Gurus, I have requirement need to sum the value, the logic is if the value is negative then time -1, I tried below two ways. one is failed, another one doesn't work. awk -F"," '{if(\$8< 0 \$8*-1 else \$8) sum+=\$8}{print sum, \$8} END{printf("%.2f\n",sum)}' awk -F","...

## Awk+colpos+negative if for 20 values

Hi All, i have 20 Obligors when ever i dont find all of them on particular row/line from each in put i need to print it in different file. using below command but it is not working please help at earliest. Steps: set -A FILENAME \$( cat...

## replacing negative values in a column with zero

Hi, i need help on replacing negative values in a column with 0. any quick fix on this? thanks much. for instance, input: 1 2.3 -0.4 -25 12 13 45 -12 desired output 1 2.3 0 0 12 13 45

## error- multiplying negative decimal values

a=10.02 pattern=-11.01 b=\$(echo | awk '{ print \$a*\$pattern}') echo \$b its not working even ALso tried `expr \$a \* \$pattern` No LUCK

## Snmp Disk Problem = Negative Values

Ok, so i monitor disk space on remote machines using snmp. Works great for me. But whenever a particular partition happens to have Terabytes of data, snmp starts reporting negative values. Can someone please tell me how to get around this problem? The AllocationUnit is 512 bytes. Weird...

## Find Where Values Change From Positive To Negative and viceversa

Hi all, I have a file that looks like shown below. I want to find places where the value in column 2 change from negative to positive and vice versa and return the value on column 1 at that point. I wonder if this is possible in shell script or awk .. please help! Here is the original data ...

## 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

## printf in bash shell not printing negative values

hi i am using printf in a script and it is not printing negative values..i have to use printf to get rid of the newline..here is my code: fin=`echo \$a - \$b | bc` printf "\${fin}," >> test these statements are in a loop. here is what i get when i try to subtract 4 from 8: ./scr1: line...

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