08-08-2013
Quote:
Originally Posted by
RavinderSingh13
Hello,
Please let know the Output you are expecting, including the input.
Thanks,
R. Singh
Dear R.Singh,
The input is a 100 column long data.
I am trying to divide column 5 with 6, 7 with 8, 9 with 10 and 11 with 12.
If columns 6,8,10 or 12 has zero, awk is complaining that fatal division by zero was attempted.
So, I thought I will read the 6,8,10 and 12th columns first, and if there is a zero, I would make the division output to be zero.
But, except for the division of column 5 with 6, all others are giving correct output. I don't know why this particular division is printing only zeroes even when column 6 is not zero.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
How can I modify my awk code to get rid of the divion by zero error message? If I run the script without an input file, it should return error message "Input file missing" but not divison by zero.
Code:
#!/bin/nawk -f
BEGIN {
if (NR == 0)
{print "Input file... (4 Replies)
Discussion started by: Pauline mugisha
4 Replies
2. Shell Programming and Scripting
I need to read the file divide 3 column with 2nd and run a modulus of 10 and check whether the remainder is zero or not if not print the entire line.
cat filename | awk '{ if ($3 / $2 % 10 != 0) print $0}'
Whats wrong with it ? (4 Replies)
Discussion started by: dinjo_jo
4 Replies
3. UNIX for Advanced & Expert Users
I received error "awk: division by zero" while executing the following statement.
SunOS 5.10 Generic_142900-15 sun4us sparc FJSV,GPUZC-M
echo 8 | awk 'END {printf ("%d\n",NR/$1 + 0.5);}' file1.lst
awk: division by zero
Can someone provide solution?
Thanks
Please use code... (11 Replies)
Discussion started by: kumar77
11 Replies
4. Shell Programming and Scripting
input
0 0 9820373 2069 0 0 11485482
awk '{print ($1/$3) / ($4/$7)}' input
error
Is there any way to fix this problem ? (25 Replies)
Discussion started by: quincyjones
25 Replies
5. Shell Programming and Scripting
input
one two three four
0 0 0 10424
0 102 0 15091
1 298 34 11111
0 10 0 1287
scripts
awk 'NR>1{print ($1/$2) / ($3/$4)}'
awk 'NR>1{ if ($1 ||$3 ||$2|| $4 == 0) print 0; else print (($1/$2)/($3/$4))}'
error
awk: division by zero
input record number 1, file rm
source line... (9 Replies)
Discussion started by: quincyjones
9 Replies
6. Shell Programming and Scripting
vmstat|awk '{print $3}'|tail -1
returns 6250511, but what I need is 24416, which is 6250511 divided by 256.
Please advise.
Thank you so much (2 Replies)
Discussion started by: Daniel Gate
2 Replies
7. Shell Programming and Scripting
hello
i try to divide 2 variables in order to get a percentage--that's why i'm not interested in integer division--but nothing seems to work
I think awk is suitable for this but i'm not quite sure how to use it..
any ideas?
here's what I want to do:
percentage = varA/varB
thank you (2 Replies)
Discussion started by: vlm
2 Replies
8. Shell Programming and Scripting
Hi Friends,
I have an input file like this
cat input
chr1 100 200 1 2
chr1 120 130 na 1
chr1 140 160 1 na
chr1 170 180 na na
chr1 190 220 0 0
chr1 220 230 nd 1
chr2 330 400 1 nd
chr2 410 450 nd nd
chr3 500 700 1 1
I want to calculate the division of 4th and 5th columns. But, if... (3 Replies)
Discussion started by: jacobs.smith
3 Replies
9. Shell Programming and Scripting
Hi Friends,
My input
chr1 100 200 1234E-02 0.01 0.05 10
chr1 100 200 14E-11 0.11 0.50 1
chr1 100 200 134E-22 0.00 0.65 111
My command
awk '{print $1"\t"$2"\t"$3"\t"$4"\t"$5"\t"$6"\t"$13}' input | awk '{v=($5/$6); print $0"\t"v}' OFS="\t" | awk '{$8=(log($8)/log(2)); print $0}'... (4 Replies)
Discussion started by: jacobs.smith
4 Replies
10. Shell Programming and Scripting
Hello,
How can I add a logic to awk to tell it to print 0 when encountering a division by zero attempted? Below is the code. Everything in the code works fine except the piece that I want to calculate read/write IO size. I take the kbr / rs and kbw / ws. There are times when the iostat data... (5 Replies)
Discussion started by: tommyd
5 Replies
COLRM(1) BSD General Commands Manual COLRM(1)
NAME
colrm -- remove columns from a file
SYNOPSIS
colrm [start [stop]]
DESCRIPTION
The colrm utility removes selected columns from the lines of a file. A column is defined as a single character in a line. Input is read
from the standard input. Output is written to the standard output.
If only the start column is specified, columns numbered less than the start column will be written. If both start and stop columns are spec-
ified, columns numbered less than the start column or greater than the stop column will be written. Column numbering starts with one, not
zero.
Tab characters increment the column count to the next multiple of eight. Backspace characters decrement the column count by one.
ENVIRONMENT
The LANG, LC_ALL and LC_CTYPE environment variables affect the execution of colrm as described in environ(7).
EXIT STATUS
The colrm utility exits 0 on success, and >0 if an error occurs.
SEE ALSO
awk(1), column(1), cut(1), paste(1)
HISTORY
The colrm command appeared in 3.0BSD.
BSD
August 4, 2004 BSD