rounding problem 1

[daddymack]

Can anyone shed any light on this, essentially what I am trying to do is read in a column of numbers and print out the number left padded with zeroes(width of 15) and no decimal place i.e

INPUT

0.69 000000000000069
7.1 000000000000710
5 000000000000500

The below script is returning strange results. (a.awk)

{
rec_amt=69.35
d_doc_amt=sprintf("%015d", rec_amt*100)
print &quot;rec_amt is >&quot;rec_amt&quot;< and d_doc_amt is >&quot;d_doc_amt&quot;<&quot;
}

echo 1 | awk -f a.awk

rec_amt is >69.35< and d_doc_amt is >000000000006934<

 

[Krunek]

Hello daddymack!

This is because awk's arithmetic is done internally in floating point. Instead %d picture you can use %f picture. See this awk examples (I use awk for DOS and Win):

awk "BEGIN { printf \"%015d\", 69.35 * 100 }"
000000000006934

"BEGIN { printf \"%015.0f\", 69.35 * 100 }"

000000000006935

See also Python's behaviour in this situation:

>>> print '%015d' % (69.35 * 100)
Traceback (innermost last):
  File &quot;<stdin>&quot;, line 1
TypeError: int argument required

>>> print '%015.0f' % (69.35 * 100)
000000000006935

I suggest you to use %f picture.

Bye!

KP.

 

[daddymack]

Thanks Krunek. Thats worked a treat.