|
|
Sponsored Content
Top Forums
UNIX for Dummies Questions & Answers
awk question about sum
Post 302593352 by civilianwarfare on Thursday 26th of January 2012 02:51:09 PM
01-26-2012
awk question about sum
Hi everyone, i need help with a simple task. I have a file withe the format:
"01/20/2012 23:10:13.979","49","49","48","19"
"01/20/2012 23:15:13.969","47","47","48","18"
"01/20/2012 23:20:13.975","47","47","45","17"
"01/20/2012 23:25:13.980","44","44","44","17"
"01/20/2012 23:30:13.970","43","43","47","14"
"01/20/2012 23:35:13.976","45","45","44","15"
"01/20/2012 23:40:13.966","45","45","43","14"
"01/20/2012 23:45:13.971","42","42","44","14"
"01/20/2012 23:50:13.977","44","44","44","13"
"01/20/2012 23:55:13.966","44","44","42","12"
I need the next result:
"01/20/2012 23:10:13.979","49","49","48","19","165"
"01/20/2012 23:15:13.969","47","47","48","18","159"
"01/20/2012 23:20:13.975","47","47","45","17","156"
"01/20/2012 23:25:13.980","44","44","44","17","149"
"01/20/2012 23:30:13.970","43","43","47","14","147"
"01/20/2012 23:35:13.976","45","45","44","15","149"
"01/20/2012 23:40:13.966","45","45","43","14","147"
"01/20/2012 23:45:13.971","42","42","44","14","140"
"01/20/2012 23:50:13.977","44","44","44","13","145"
"01/20/2012 23:55:13.966","44","44","42","12","142"
Im neewbie with awk, i try with:
awk '
BEGIN {FS=OFS=","}
{
sum=0; n=0
for(k=2;k<=NF;k++)
{sum+=$k; ++n}
print $0, sum
}'file.txt > newfile.txt
But its just add a 0 at the end.
I'm stuck with this for a couple of hours, any idea? THX A LOT!!
"01/20/2012 23:10:13.979","49","49","48","19"
"01/20/2012 23:15:13.969","47","47","48","18"
"01/20/2012 23:20:13.975","47","47","45","17"
"01/20/2012 23:25:13.980","44","44","44","17"
"01/20/2012 23:30:13.970","43","43","47","14"
"01/20/2012 23:35:13.976","45","45","44","15"
"01/20/2012 23:40:13.966","45","45","43","14"
"01/20/2012 23:45:13.971","42","42","44","14"
"01/20/2012 23:50:13.977","44","44","44","13"
"01/20/2012 23:55:13.966","44","44","42","12"
I need the next result:
"01/20/2012 23:10:13.979","49","49","48","19","165"
"01/20/2012 23:15:13.969","47","47","48","18","159"
"01/20/2012 23:20:13.975","47","47","45","17","156"
"01/20/2012 23:25:13.980","44","44","44","17","149"
"01/20/2012 23:30:13.970","43","43","47","14","147"
"01/20/2012 23:35:13.976","45","45","44","15","149"
"01/20/2012 23:40:13.966","45","45","43","14","147"
"01/20/2012 23:45:13.971","42","42","44","14","140"
"01/20/2012 23:50:13.977","44","44","44","13","145"
"01/20/2012 23:55:13.966","44","44","42","12","142"
Im neewbie with awk, i try with:
awk '
BEGIN {FS=OFS=","}
{
sum=0; n=0
for(k=2;k<=NF;k++)
{sum+=$k; ++n}
print $0, sum
}'file.txt > newfile.txt
But its just add a 0 at the end.
I'm stuck with this for a couple of hours, any idea? THX A LOT!!
|
|
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi All,
I am trying to add a column that contains the sum of the previous column repeated. IE
1
2
3
4
I would like to get:
1 10
2 10
3 10
4 10
Advice? I can get
1 1
2 3
3 6 (4 Replies)
Discussion started by: baconbasher
4 Replies
2. Shell Programming and Scripting
Hi there,
I have a logfile which has the following layout:
20080812 0 20
20080812 12 10
20080812 12 10
20080812 12 10
I want to sum the "12" on the last 3 lines and save the "20" on the first line. The final output should be
20080812 36 20
I think that should me more easier with... (6 Replies)
Discussion started by: BufferExploder
6 Replies
3. Shell Programming and Scripting
Hi,consider this fields,
$1 $2 $3
981 0 1
984 0 4
985 1 0
987 0 2
990 0 0
993 0 3
995 2 0
996 0 1
999 0 4
for each occurence of zero in column $2 and $3 I need to sum $1 fields, so for example, in this piece of code the result of $1 is 8910. I'm sure... (2 Replies)
Discussion started by: cv313x
2 Replies
4. Shell Programming and Scripting
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..
# awk '{sum+=$1} END {print sum}' datafile
2.15079e+06 (3 Replies)
Discussion started by: rveri
3 Replies
5. Shell Programming and Scripting
Hi all,
I need to sum values for fields in a delimited file as below:
2010-03-05|||
2010-03-05|||123
2010-03-05|467.621|369.532|
2010-03-06|||
2010-03-06||2|
2010-03-06|||444
2010-03-07|||
2010-03-07|||
2010-03-07|655.456|1019.301|
Code used is:
nawk -F "|" ' { sum +=... (7 Replies)
Discussion started by: Katabatic
7 Replies
6. Shell Programming and Scripting
I have a input.txt file which have 3 fields separate by a comma
place, os and timediff in seconds
tampa,win7, 2575
tampa,win7, 157619
tampa,win7, 3352
dallas,vista,604799
greenbay,winxp, 14400
greenbay,win7 , 518400
san jose,winxp, 228121
san jose,winxp, 70853
san jose,winxp, 193514... (5 Replies)
Discussion started by: sabercats
5 Replies
7. Shell Programming and Scripting
Hello all,
how would one go about writing a command using sed/awk that will give me an output that can sum up the number of time each user has done something and also add the amount of time...
so output would be for example
"smiths has run 3 process and for time taken of value: 224"
... (5 Replies)
Discussion started by: crazy_max
5 Replies
8. Shell Programming and Scripting
input
A1 B1 A2 B2
0 0 1 1
1 0 0 1
0 1 1 0
1 1 1 1
Output
label A1 B1 A2 B2
A1 2 1 1 2
B1 1 2 2 1
A2 1 2 3 2
B2 2 1 2 3
Ex:
The number of times that A1 and B1 row values are both 1 should be printed as output.
The last row of A1 and B1 in the input match by having 1 in both... (4 Replies)
Discussion started by: quincyjones
4 Replies
9. Shell Programming and Scripting
Hi,
I have an awk command that I am using, and part of it sums COL_9 however when I read the output it is not including decimal places;
awk '
BEGIN{FS=OFS=","}
NR==1{print;next}
{a+=$9
c = $12
d = $18
}
END{for(i in a) {split(i,b,";"); print $1, $2, $3, b, $5, $6, b, b, a, $10, $11,... (1 Reply)
Discussion started by: Ads89
1 Replies
10. Shell Programming and Scripting
This is my file
vol0 285GB
vol0.snapshot 15GB
vol11_root 0GB
vol12_root 47GB
vol12_root.snapshot 2GB
I need the output
vol0 285GB,vol0.snapshot 15GB,sum-300GB
vol11_root 0GB,nosnap,sum-0Gb
vol12_root 47GB,vol12_root.snapshot 2GB,49GB
I was trying to use paste -d, --. But... (9 Replies)
Discussion started by: ranjancom2000
9 Replies
LEARN ABOUT SUNOS
sum
sum(1) User Commands sum(1) NAME
sum - print checksum and block count for a file SYNOPSIS
sum [-r] [file...] DESCRIPTION
The sum utility calculates and prints a 16-bit checksum for the named file and the number of 512-byte blocks in the file. It is typically used to look for bad spots, or to validate a file communicated over some transmission line. OPTIONS
The following options are supported: -r Use an alternate (machine-dependent) algorithm in computing the checksum. OPERANDS
The following operands are supported: file A path name of a file. If no files are named, the standard input is used. USAGE
See largefile(5) for the description of the behavior of sum when encountering files greater than or equal to 2 Gbyte ( 2**31 bytes). ENVIRONMENT VARIABLES
See environ(5) for descriptions of the following environment variables that affect the execution of sum: LC_CTYPE, LC_MESSAGES, and NLSPATH. EXIT STATUS
The following exit values are returned. 0 Successful completion. >0 An error occurred. ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | |Availability |SUNWesu | |CSI |enabled | +-----------------------------+-----------------------------+ SEE ALSO
cksum(1), sum(1B), wc(1), attributes(5), environ(5), largefile(5) DIAGNOSTICS
"Read error" is indistinguishable from end of file on most devices; check the block count. NOTES
Portable applications should use cksum(1). sum and usr/ucb/sum (see sum(1B)) return different checksums. SunOS 5.10 7 Nov 1995 sum(1)