|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Sum of decimal numbers in column
Post 302454997 by tdev457 on Monday 20th of September 2010 01:49:23 PM
09-20-2010
Thanks!!!
I use this code before
awk '{ SUM += $1} END { print SUM }' file
-----------------------------------------------------------------
Example:
cat file
-------------
13.45
2.11
123.12
then awk gives me result 138??? (on my Centos)
on eeePC running Xandros result is correct!!!
What is the reason?
I use this code before
awk '{ SUM += $1} END { print SUM }' file
-----------------------------------------------------------------
Example:
cat file
-------------
13.45
2.11
123.12
then awk gives me result 138??? (on my Centos)
on eeePC running Xandros result is correct!!!
What is the reason?
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
i want to sum all nubers in one column. Example:
12.23
11
23.01
3544.01
I'm trying to do this in awk, but it doesn't work properly.
Seems like awk is summing only integers, for example:
12
11
23
3544
It cuts off numbers after dot.
I used this command:
akw /text/ file.txt |nawk... (1 Reply)
Discussion started by: iahveh
1 Replies
2. Shell Programming and Scripting
How can i devide decimal numbers?
I am getting this kind of error:
line 18: 200.2/40.234: syntax error in expression (error token is ".2/40.234")
What can i do to work around this problem?
Thanks for any advice. (4 Replies)
Discussion started by: Vozx
4 Replies
3. Shell Programming and Scripting
Hi friends
How can I use "for loop" for decimal numbers?
ex: 0.1 < x < 0.6
I used this commands but does'nt work.
LIMIT=0.6
for ((x=0.1; x<=LIMIT; x++))
do
-
-
-
done
Many thanks (1 Reply)
Discussion started by: snow
1 Replies
4. Shell Programming and Scripting
Hello...
I am new to unix and I am wondering if in a C-shell script , Are we supposed to use only whole numbers........ for example..if a program needs to calculate the average of some numbers........
@ avg = (($1 +$2 + $3)/3)) is returning a whole number.........How can a decimal be... (7 Replies)
Discussion started by: ravindra22
7 Replies
5. UNIX for Dummies Questions & Answers
Hi,
I have a small requirement where i need to sum up a column in a text file.
Input file
66ab 000000 534385 -00000106350.00
66cd 000000 534485 -00013364511.00
66ad 000000 534485 -00000426548.00
672a 000000 534485 000000650339.82... (5 Replies)
Discussion started by: pssandeep
5 Replies
6. Shell Programming and Scripting
I am running the following script :
cat ind_sls_extr_UX.out_sorted | while read each_rec
do
count=`echo "${each_rec}" | cut -c1-2`
if
then
final_amount=0
amount=`echo "${each_rec}" | cut -c280-287`
echo "${amount}"
final_amount=`expr ${amount} + ${amount}`
... (7 Replies)
Discussion started by: mady135
7 Replies
7. UNIX for Dummies Questions & Answers
Dear All,
I have a file with only one column. And I want to add every 3 consecutive numbers together and print the result.
Input File:
21.1
10
10
55
11
99
10
8
4
Expected Output:
41.1 (5 Replies)
Discussion started by: NamS
5 Replies
8. Post Here to Contact Site Administrators and Moderators
HI Everyone,
I have below source file
AAA|NAME1|ADDRESS1|300.20
BBB|NAME2|ADDRESS2|400.31
CCC|NAME3|ADDRESS3|300.34
I have requirement where I need to sum up fourth field in above fixed width pipe delimited flat file. When I use below code, it gives me value 1001.00
But I am expecting... (1 Reply)
Discussion started by: patricjemmy6
1 Replies
9. UNIX for Beginners Questions & Answers
Hi!
I found and then adapt the code for my pipeline...
awk -F"," -vOFS="," '{printf "%0.2f %0.f\n",$2,$4}' xxx > yyy
I add -F"," -vOFS="," (for input and output as csv file) and I change the columns and the number of decimal...
It works but I have also some problems... here my columns
... (7 Replies)
Discussion started by: echo manolis
7 Replies
10. Shell Programming and Scripting
I used the below script to Sum up a field in a file based on some unique values. But the problem is when it is summing up the units, it is truncating to 2 decimals and not 6 decimals as in the input file (Input file has the units with up to 6 Decimals – Sample data below, when the units in the 2... (4 Replies)
Discussion started by: brlsubbu
4 Replies
LEARN ABOUT OPENSOLARIS
mlib_signalconv_f32s_f32s
mlib_SignalConv_S16_S16_Sat(3MLIB) mediaLib Library Functions mlib_SignalConv_S16_S16_Sat(3MLIB) NAME
mlib_SignalConv_S16_S16_Sat, mlib_SignalConv_S16S_S16S_Sat, mlib_SignalConv_F32_F32, mlib_SignalConv_F32S_F32S - signal convolution SYNOPSIS
cc [ flag... ] file... -lmlib [ library... ] #include <mlib.h> mlib_status mlib_SignalConv_S16_S16_Sat(mlib_s16 *dst, const mlib_s16 *src1, const mlib_s16 *src2, mlib_s32 m, mlib_s32 n); mlib_status mlib_SignalConv_S16S_S16S_Sat(mlib_s16 *dst, const mlib_s16 *src1, const mlib_s16 *src2, mlib_s32 m, mlib_s32 n); mlib_status mlib_SignalConv_F32_F32(mlib_f32 *dst, const mlib_f32 *src1, const mlib_f32 *src2, mlib_s32 m, mlib_s32 n); mlib_status mlib_SignalConv_F32S_F32S(mlib_f32 *dst, const mlib_f32 *src1, const mlib_f32 *src2, mlib_s32 m, mlib_s32 n); DESCRIPTION
Each of these functions performs convolution. For monaural signals, the following equation is used: m-1 dst[i] = SUM (src1[j] * src2[i - j]) if m <= n j=0 n-1 dst[i] = SUM (src2[j] * src1[i - j]) if m > n j=0 where i = 0, 1, ..., (m + n - 2). For stereo signals, the following equation is used: m-1 dst[2*i] = SUM (src1[2*j] * src2[2*(i - j)]) j=0 m-1 dst[2*i + 1] = SUM (src1[2*j + 1] * src2[2*(i - j) + 1]) j=0 if m <= n, or n-1 dst[2*i] = SUM (src2[2*j] * src1[2*(i - j)]) j=0 n-1 dst[2*i + 1] = SUM (src2[2*j + 1] * src1[2*(i - j) + 1]) j=0 if m > n; where i = 0, 1, ..., (m + n - 2). PARAMETERS
Each of the functions takes the following arguments: dst Destination signal array. src1 First source signal array. src2 Second source signal array. m Number of samples in the first source signal array. n Number of samples in the second source signal arrays. RETURN VALUES
Each of the functions returns MLIB_SUCCESS if successful. Otherwise it returns MLIB_FAILURE. ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Interface Stability |Committed | +-----------------------------+-----------------------------+ |MT-Level |MT-Safe | +-----------------------------+-----------------------------+ SEE ALSO
attributes(5) SunOS 5.11 2 Mar 2007 mlib_SignalConv_S16_S16_Sat(3MLIB)