Visit Our UNIX and Linux User Community

awk: division by zero

Thread Tools Search this Thread
Top Forums UNIX for Advanced & Expert Users awk: division by zero
# 1  
Old 12-20-2010
awk: division by zero

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?


Moderator's Comments:
Mod Comment
Please use code tags when posting data and code samples!

Last edited by vgersh99; 12-20-2010 at 07:26 PM.. Reason: code tags, please!
# 2  
Old 12-20-2010
Not sure what exactly you are trying to do here.
awk action is being executed in END block, when all input lines are processed.
In END block, there is no input line to process, so $1 is zero/null. So "division by zero" error.
Following should work.
echo 8 | awk '{printf ("%d\n",NR/$1 + 0.5);}'

# 3  
Old 12-20-2010
what are you trying to do?
why are you echo-ing into awk AND passing the input file 'file1.lst'?
NOTE: on Solaris, use /usr/bin/nawk or /usr/xpg4/bin/awk - instead of plain old 'awk'
# 4  
Old 12-20-2010
I am trying to total number of lines divided by 8.

---------- Post updated at 06:44 PM ---------- Previous update was at 06:39 PM ----------

Anurag Singh,

I had tried with your code. But it is not working. So help me on this.

# 5  
Old 12-20-2010
awk 'END {printf ("%d\n",NR/8);}' file1.lst

echo $(($(wc -l<file1.lst)/8))

# 6  
Old 12-20-2010
Originally Posted by anurag.singh
awk 'END {printf ("%d\n",NR/8);}' file1.lst

echo $(($(wc -l<file1.lst)/8))

not all awk-s have 'NR' available in the 'END' block.
nawk '{nr=NR}END{printf ("%d\n",nr/div + 0.5);}' div=8 file1.lst

# 7  
Old 12-20-2010
Anurag singh,

I would like to use only awk. I know that which was mentioned in your last reply.


Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk - continue when encountered division error

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

2. Shell Programming and Scripting

awk Division By Zero Bypass

Hi Friends, I don't understand why "a" is always being printed as zero, when I execute the following command. awk '{if($6||$8||$10||$12==0)a=b=c=d=0;else (a=$5/$6);(b=$7/$8);(c=$9/$10);(d=$11/$12); {print... (6 Replies)
Discussion started by: jacobs.smith
6 Replies

3. Shell Programming and Scripting

awk - Division with condition

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

4. Shell Programming and Scripting

variables division with awk

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

5. Shell Programming and Scripting

awk & division

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

6. Shell Programming and Scripting

Division problem -Awk

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

7. Shell Programming and Scripting

awk division error - 0

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

8. Shell Programming and Scripting

awk error message: division by zero attempted

Hi, I'm executing unixbench tool v4.1 on an embedded system and I'm getting these error messages: Execl Throughput 1 2 3awk: /unixbench/unixbench-4.1.0/pgms/loops.awk:38: (FILENAME=- FNR=4) fatal: division by zero attempted Pipe Throughput 1 2 3 4 5 6 7 8 9 10awk:... (3 Replies)
Discussion started by: rogelio
3 Replies

9. Shell Programming and Scripting

awk Division and modulus

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

10. Shell Programming and Scripting

Division by zero error message in AWK

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

Featured Tech Videos