Calculate total sum from a file

TehOne · #1 (**permalink**) 05-27-2009

The file content is dynamic and using this format:

Code:

name1 number1
name2 number2
name3 number3
name4 number4
....................

Need a smooth way to calculate the sum of all the numbers in that file (number1 + number2 + number3 + number4........ = total )

Rhije · #2 (**permalink**) 05-27-2009

Oh thats an easy one. There is also 'bc' but that would be for really hard core math, and then there is "let".. but dont worry with those.. you can just use awk.

Code:

-bash-3.2$ cat test.txt
one 1
two 2
three 3
four 4
five 5
six 6
seven 7
eight 8
nine 9
ten 10

-bash-3.2$ awk '{count += $2;} END { print count; }' test.txt
55

TehOne · #3 (**permalink**) 05-27-2009

Works like a harm, thanks!

Rhije · #4 (**permalink**) 05-27-2009

No problem!

rakesh_pagadala · #5 (**permalink**) 05-27-2009

Hi all,
I am new to this forums so was not able to find to post new forums hence i posted in the already existing form please help me with the below requirement

I have a requirement as below I want to grep xyz and get the result domain name as "unix.com"

3.209.12.09 xyz xyz.unix.com

durden_tyler · #6 (**permalink**) 05-27-2009

Quote:

Originally Posted by rakesh_pagadala

...
I have a requirement as below I want to grep xyz and get the result domain name as "unix.com"

3.209.12.09 xyz xyz.unix.com

Something like this:

Code:

$
$ cat input.txt
3.209.12.09 xyz xyz.unix.com
$
$ awk '{sub("xyz.","",$3); print $3}' input.txt
unix.com
$

tyler_durden

rakesh_pagadala · #7 (**permalink**) 05-27-2009

Quote:

Originally Posted by durden_tyler

Something like this:

Code:

$
$ cat input.txt
3.209.12.09 xyz xyz.unix.com
$
$ awk '{sub("xyz.","",$3); print $3}' input.txt
unix.com
$

tyler_durden

Thanks for your help !!! But need some more of your help

There is an another clause over here which i found just now ... xyz.unix.com can come any where in the line it need not be at $3 every time

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
awk script to calculate total	appsguy616	Shell Programming and Scripting	2	11-25-2008 11:21 AM
Awk help needed to calculate total	senthilkumar_ak	Shell Programming and Scripting	7	08-22-2008 12:47 AM

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: