Visit Our UNIX and Linux User Community


problem with floating point numbers in awk


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting problem with floating point numbers in awk
# 1  
Old 06-24-2005
problem with floating point numbers in awk

hi all, i have the following problem using awk in a script

i want to read the values from a column with real numbers and calculate the mean.the problem is that when i use a statement such as this

num = $4

i cant find a way to convert the variable from string to floating point to perform any operations.i tried the following

sum = num + 0.0

but sum is equal to 0 after this statement, num is not treated as floating point number but as string Smilie

any help would be appreciated

edit : i am using awk 3.1.4 on Suse 9.2
# 2  
Old 06-24-2005
Quote:
Originally Posted by kanagias
hi all, i have the following problem using awk in a script

i want to read the values from a column with real numbers and calculate the mean.the problem is that when i use a statement such as this

num = $4

i cant find a way to convert the variable from string to floating point to perform any operations.i tried the following

sum = num + 0.0

but sum is equal to 0 after this statement, num is not treated as floating point number but as string Smilie

any help would be appreciated

edit : i am using awk 3.1.4 on Suse 9.2

what "operation" are you trying to perform?
for example:
echo '1.2' | nawk '{num=$1; print num, num+3.5}'
# 3  
Old 06-24-2005
i just want to do simple mathematical operations.to be more clear here is a test awk script i used

BEGIN{}

{

num = $1
sum += num

}

END {
print sum
}

where column 1 contains the floating point numbers
print sum produces 0...

i tried to add 0.0 to num to force to be treated as number and not as string but that didnt work either
# 4  
Old 06-24-2005
produces a fine floating point number for me - Solaris's nawk:
Code:
nawk '{sum +=$1} END{print sum}' <<!
1.2
1.3
1.4
!

# 5  
Old 06-24-2005
neither awk or gawk works for me... Smilie
anyway thanks for replying
# 6  
Old 06-24-2005
Quote:
Originally Posted by kanagias
neither awk or gawk works for me... Smilie
anyway thanks for replying
works under gawk for me....
there must be something strange with your 'data source'
# 7  
Old 06-24-2005
yes you were right.the problem was with the dots (.), for some reason awk recognizes only the comma as a separator of the integral from the fractal part of the number.thanks for the help man

Previous Thread | Next Thread
Test Your Knowledge in Computers #917
Difficulty: Easy
Unix time is also known as Epoch time.
True or False?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Comparison of floating point numbers in bash

I have the following code snippet in bash if ]; then minm=`echo "$diff" | bc` fi It works well for most of the cases. However lets say diff is -0.17 and minm is -0.0017. In such a case the comparison seems to fail. Is the correct way to compare a mixture of positive and... (12 Replies)
Discussion started by: ngabrani
12 Replies

2. Shell Programming and Scripting

Floating Point Numbers in c shell!

I have started using bash but this script which I am working on it, is in c chell. So here is my simple problem: set x = 0.4124\0.234 echo $x 0.4124.0.234 Same operation in Bash gives me correct result in my terminal. So there is something with my c shell that is causing this behaviour.... (8 Replies)
Discussion started by: dixits
8 Replies

3. UNIX for Dummies Questions & Answers

Add floating point numbers from file

How do I use bash to add all the floating point numbers saved in a file like this? 490.47 244.61 263.07 131.59 246.81 115.20 (3 Replies)
Discussion started by: locoroco
3 Replies

4. Programming

Testing floating point numbers

Hi guys I have problem with my simple calculator, author of my book wrote One way I tried is to test if one the inpur number is grater than zero, and then substatct And my protptype function is #include <stdio.h> int main(void) { float a, b , result; ... (11 Replies)
Discussion started by: solaris_user
11 Replies

5. Shell Programming and Scripting

floating point number problem

Hello folks I Hope everyone is fine. I am calculating number of bytes calculation from apache web log. awk '{ sum += $10 } END { print sum }' /var/httpd/log/mydomain.log 7.45557e+09 it show above number, what should i do it sow number like 7455, i mean if after decimal point above 5 it... (5 Replies)
Discussion started by: learnbash
5 Replies

6. Shell Programming and Scripting

How to compare floating point numbers in shell script?

How can we compare 2 floating point numbers in SHELL script? (11 Replies)
Discussion started by: dearanik
11 Replies

7. Shell Programming and Scripting

floating point numbers in if

# if > then > echo "1" > else > echo "2" > fi -bash: How can i compare floating point numbers inside statement? (15 Replies)
Discussion started by: proactiveaditya
15 Replies

8. Shell Programming and Scripting

sed to extract only floating point numbers from HTML

Hi All, I'm trying to extract some floating point numbers from within some HTML code like this: <TR><TD class='awrc'>Parse CPU to Parse Elapsd %:</TD><TD ALIGN='right' class='awrc'> 64.50</TD><TD class='awrc'>% Non-Parse CPU:</TD><TD ALIGN='right' class='awrc'> ... (2 Replies)
Discussion started by: pondlife
2 Replies

9. Shell Programming and Scripting

How to Compare Floating point / real numbers

Hai, Can you please guide me, to compare the floating point numbers. Eg. If then echo "value1 is grater " fi This code is not working properly when i excuted with floating values or real numbers (13 Replies)
Discussion started by: padarthy
13 Replies

10. Programming

floating point problem

Hi all! Hi all! I am working with a problem to find the smallest floating point number that can be represented. I am going in a loop ,stating with an initial value of 1.0 and then diving it by 10 each time thru the loop. So the first time I am getting o.1 which I wanted.But from the next... (4 Replies)
Discussion started by: vijlak
4 Replies

Featured Tech Videos