Thanks a lot for your hits.
Thanks for hits.
After I try the following command, it gives the sum of all column.
Is it I should cat the above figure with the raw input data to get desired output result?
Got any faster way to solve it?
Thanks for advice.
Hi, i have a file which content the following:
>cat cols
data a:23:data
data b:76:data
data c:-30:data
i would like to sum up the value of column 2, but the result that return to me is 0. Can anyone help?
i'm using this code to do the sum
awk -F" " 'BEGIN {x=0} {x+=$2} END {print... (5 Replies)
Here is my file name countries
USSR 8650 262 Asia
Canada 3852 24 North America
China 3692 866 Asia
USA 3615 219 North America
Brazil 3286 116 South America
India 1269 637 Asia
Argentina 1072 ... (8 Replies)
Hello,
I just need to print the # of columns for each line of the input file.
The input file uses the ascii 009 tab character.
I specify this character as the FS (field separator) in the BEGIN section, and I know the FS character is correct because I can print it.
When I try to print the #... (1 Reply)
Input file
data US 100.25
data ENG 235.01
data US 23.12
data ENG 23.01
END UK 230.50
END Russia 20.00
.
.
Desired output
data US 123.37
data ENG 258.02
END UK 230.50
END Russia 20.00
.
. (1 Reply)
Input file
1159,310, 159797120,159817366,
142,199,218,91, 26551038,26551729,26552411,26552894,
91,273,349, 26481990,26482133,26482477,
Desired output result
19087
549 483 265
52 71
I have long list of input file as shown above.
I would like to use the info at... (2 Replies)
Hi I have this file which contains
Al,AADESH,id1_0,23,2013-01-28,2,2
Al,AADESH,id1_0,23,2013-01-29,4,4
Al,AADESH,id1_0,23,2013-01-30,2,1
Al,AADESH,id1_0,31,2013-01-29,1,1
Al,AESH,id1_0,31,2013-01-31,2,2
Al,AESH,id2_2,23,2013-01-29,1,1
Al,AESH,id2_2,31,2013-01-31,1,1 ... (5 Replies)
Hi
i need to calculate the total of a column from a file in ksh
vi file.txt
System : CBSE ent=0.1 me=Cap
Subject Maths Science
xxxxx 56 98
yyyy 89 67
ooo 67 32
Here i need to calculate only the total of Maths column alone i.e., 56+89+67
... (4 Replies)