scripting/awk help : awk sum output is not comming in regular format. Pls advise.

rveri · #1 (**permalink**) 3 Weeks Ago

Hi Experts,

I am adding a column of numbers with awk , however not getting correct output:

# awk '{sum+=$1} END {print sum}' datafile
2.15291e+06

How can I getthe output like : 2152910

Thank you..

Code:

 
# awk '{sum+=$1} END {print sum}' datafile 
2.15079e+06

#cat datafile
36171
3832
1361
1229
56096
1629
4421
3654
118455
52231
51299
188963
55128
105351
1229
1606
109271
13050
150202
92293
1157
54625
163311
1253
45338
628891
1357
209511

Scrutinizer · #2 (**permalink**) 3 Weeks Ago

Code:

awk '{sum+=$1} END {printf "%.f\n",sum}' datafile

rveri · #3 (**permalink**) 3 Weeks Ago

Scrutinizer ,
nice ..working Thanks.

Skaperen · #4 (**permalink**) 3 Weeks Ago

If all the numbers are integers, you can use %d (or %u if always positive) instead of %.f

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
regular expression format string in one line.	jimmy_y	Shell Programming and Scripting	2	3 Weeks Ago 10:30 PM
its been a while, but its comming back!	flyboy	High Level Programming	2	05-01-2009 02:06 AM
how to use regular expression in Bash Shell Scripting	sunitachoudhury	Shell Programming and Scripting	5	03-13-2008 01:12 AM
problem with comming out on internet	steffa	UNIX for Advanced & Expert Users	1	09-13-2004 09:30 AM
regular expression format	trynew	Shell Programming and Scripting	1	06-21-2002 12:26 PM

Bits Awarded / Charged to Scrutinizer for this Post
Date	User	Comment	Amount
3 Weeks Ago	rveri	N/A	20

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by