[SOLVED] convert a number into millions

santosh0782 · 03-22-2014, 11:06 AM

Hi,

can we convert any number like 768565746354646 to millions using awk?

or is there any link for such type of conversions so that i'll study it.

jdkaye · 03-22-2014, 11:19 AM

I'm not sure what you mean by "converting ... to millions". Do you mean 768565746.354646 millions or 768565746.354646 X 10^6? Please show us what kind of output you want.
jdk

santosh0782 · 03-22-2014, 11:30 AM

Quote:

Originally Posted by jdkaye

I'm not sure what you mean by "converting ... to millions". Do you mean 768565746.354646 millions or 768565746.354646 X 10^6? Please show us what kind of output you want.
jdk

would like to have output like 768565746.354646 M

grail · 03-22-2014, 11:38 AM

So what have you tried with awk and where are you stuck?

metaschima · 03-22-2014, 07:47 PM

There's no conversion involved here, there is division involved here, and yes awk can do basic math.

santosh0782 · 03-22-2014, 10:35 PM

Quote:

Originally Posted by grail

So what have you tried with awk and where are you stuck?

i tried this:

x=87654987
echo $x|awk '{ printf "%.4f M\n", $1 / 1000000 }'

output:
87.6550 M

is this correct way to show values in millions?

jdkaye · 03-23-2014, 12:37 AM

Quote:

Originally Posted by santosh0782

i tried this:

x=87654987
echo $x|awk '{ printf "%.4f M\n", $1 / 1000000 }'

output:
87.6550 M

is this correct way to show values in millions?

That's one way. There are many ways to show values in millions. This is one of them. I don't know what you mean by "correct way".
jdk

santosh0782 · 03-23-2014, 01:31 AM

Quote:

Originally Posted by jdkaye

That's one way. There are many ways to show values in millions. This is one of them. I don't know what you mean by "correct way".
jdk

ok. Thanks a lot :-)

grail · 03-23-2014, 05:28 AM

I agree with jdk. Ultimately the question is back to you, ie does that answer look like what you want or not?

If it does and you have a solution, please mark as SOLVED.