error "awk: (FILENAME=- FNR=23) fatal: division by zero attempted"


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting error "awk: (FILENAME=- FNR=23) fatal: division by zero attempted"
# 1  
Old 05-10-2009
Question error "awk: (FILENAME=- FNR=23) fatal: division by zero attempted"

Hi ,

I have file :
Quote:
16 0
27 0
26 0
44 0
28 0
23 0
187 0
14 1
98 1
41 0
47 0
61 0
78 2
40 0
105 1
175 1
175 0
67 0
118 0
30 0
149 1
210 1
0 0
0 0
112 0
after i run this command :
Quote:
cat file | awk '{print $3" ,"100*($3/($3+$4))" ,"}'
there are error
Quote:
16 ,100 ,
27 ,100 ,
26 ,100 ,
44 ,100 ,
28 ,100 ,
23 ,100 ,
187 ,100 ,
14 ,93.3333 ,
98 ,98.9899 ,
41 ,100 ,
47 ,100 ,
61 ,100 ,
78 ,97.5 ,
40 ,100 ,
105 ,99.0566 ,
175 ,99.4318 ,
175 ,100 ,
67 ,100 ,
118 ,100 ,
30 ,100 ,
149 ,99.3333 ,
210 ,99.5261 ,
awk: (FILENAME=- FNR=23) fatal: division by zero attempted
can we print blank line if output error ??

thanks.. ^^
# 2  
Old 05-10-2009
i don't see where you have a third or fourth column.
# 3  
Old 05-10-2009
oops sorry should be like this :
Quote:
cat file | awk '{print $1" ,"100*($1/($1+$2))" ,"}'
# 4  
Old 05-11-2009
skin the useless cat.
Code:
awk '$1!=0 || $2!=0{print $1" ,"100*($1/($1+$2))" ,"}' file

# 5  
Old 05-11-2009
yap thanks.. but we should print $1
so we missing $1 in line 23 and 24 ??

Quote:
16 ,100 ,
27 ,100 ,
26 ,100 ,
44 ,100 ,
28 ,100 ,
23 ,100 ,
187 ,100 ,
14 ,93.3333 ,
98 ,98.9899 ,
41 ,100 ,
47 ,100 ,
61 ,100 ,
78 ,97.5 ,
40 ,100 ,
105 ,99.0566 ,
175 ,99.4318 ,
175 ,100 ,
67 ,100 ,
118 ,100 ,
30 ,100 ,
149 ,99.3333 ,
210 ,99.5261 ,
------>> line 23 and 24
112 ,100 ,
can we print blank line for this case ?
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Fatal division by zero attempted

Hello. I'm writing an awk script that looks at a .csv file and calculates the weighted grade based on the scores and categories in the file. I keep getting a fatal division by zero attempted error and I know what it means but I've been looking over the code for awhile and am not sure what is... (4 Replies)
Discussion started by: Eric7giants
4 Replies

2. Shell Programming and Scripting

Division by zero attempted error during linear conversion of values between 0.25 to 1

I want to implement the below formula with awk oneliner new_value = ((old_value - old_min) / (old_max - old_min) ) * (new_max - new_min) + new_min I want to pass the value of old_min and old_min as variable. Here is what I did for this old_min=$(awk 'BEGIN{a=100000000000}{if ($10<0+a) a=$10}... (2 Replies)
Discussion started by: sammy777888
2 Replies

3. Solaris

Install Apache 2.4.20 on Solaris 10 --- Error "ld: fatal: file ab.o: wrong ELF class: ELFCLASS32"

I am following the "Compilling and Installing" guide from Apache > HTTP Server > Documentation > Version 2.4 page The configure running OK: # export CC="gcc -m64" # ./configure \ --prefix=/usr/local/apache2/httpd-2.4.20 \ --with-port=80 \ --with-mpm=worker \ --enable-mods-shared=most \... (0 Replies)
Discussion started by: jhuang
0 Replies

4. Shell Programming and Scripting

awk fatal:division by zero attempted bypass with a condtion

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

5. Shell Programming and Scripting

Awk: cmd. line:1: fatal: division by zero attempted

when i try the snippet in the console its working fine: ps awwwux | grep php-fpm | grep -v grep | grep -v master | awk '{total_mem = $6 * 1024 + total_mem; total_proc++} END{printf("%d\n", total_mem / total_proc)}' output: but when i try the bash script: #!/bin/sh # -*- sh -*- #... (3 Replies)
Discussion started by: danieloooo
3 Replies

6. UNIX for Dummies Questions & Answers

"tail -n 1 filename" error while "head -n 1 filename" is ok?

Hi all, I was wondering why tail -n 2 filename produce an error when I manage to do similar command on head -n 2 filename SunOS{type8code0}: tail -n 2 filename usage: tail ] tail ] (2 Replies)
Discussion started by: type8code0
2 Replies

7. Shell Programming and Scripting

awk command to replace ";" with "|" and ""|" at diferent places in line of file

Hi, I have line in input file as below: 3G_CENTRAL;INDONESIA_(M)_TELKOMSEL;SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL My expected output for line in the file must be : "1-Radon1-cMOC_deg"|"LDIndex"|"3G_CENTRAL|INDONESIA_(M)_TELKOMSEL"|LAST|"SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL" Can someone... (7 Replies)
Discussion started by: shis100
7 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. HP-UX

XIO: fatal IO error 232 (Connection reset by peer) on X server "192.168.1.239:0.0"

Hi All... I'm newbie here..., i have problem when installing oracle9206, i use HPUX 11.11, i'm using Xmanager enterprise 2.1 for forwarding from server A to my laptop # export DISPLAY=192.168.1.239:0.0 # echo $DISPLAY output ==> 192.168.1.239:0.0 at the oracle directory, i execute ... (3 Replies)
Discussion started by: grimanda
3 Replies

10. UNIX for Dummies Questions & Answers

Explain the line "mn_code=`env|grep "..mn"|awk -F"=" '{print $2}'`"

Hi Friends, Can any of you explain me about the below line of code? mn_code=`env|grep "..mn"|awk -F"=" '{print $2}'` Im not able to understand, what exactly it is doing :confused: Any help would be useful for me. Lokesha (4 Replies)
Discussion started by: Lokesha
4 Replies
Login or Register to Ask a Question