Column containing sum using awk

baconbasher · #1 (**permalink**) 07-25-2008

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 10

but the former is really what I want.

Thanks

krishmaths · #2 (**permalink**) 07-25-2008

If you are okay to use two commands, you may try this

Code:

export s=`awk '{sum+=$1} END{print sum}' tempfile`; awk -v var=$s '{print $1" "var}' tempfile

baconbasher · #3 (**permalink**) 07-25-2008

Yeah...I thought about doing it that way, I had just hoped there was cleaner way of doing it.

Thanks.

radoulov · #4 (**permalink**) 07-25-2008

Use nawk or /usr/xpg4/bin/awk on Solaris.

Code:

awk 'NR==FNR{_+=$1;next}$0=$0FS _' file file

baconbasher · #5 (**permalink**) 07-25-2008

Thanks.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Changing one column of delimited file column to fixed width column	manneni prakash	Shell Programming and Scripting	5	06-22-2009 06:27 AM
how to read the column and print the values under that column	gemini106	Shell Programming and Scripting	6	03-28-2008 07:05 AM
How to check Null values in a file column by column if columns are Not NULLs	Mandab	Shell Programming and Scripting	7	03-15-2008 09:57 AM
replace a column values with the first value in column	sumeet	UNIX for Advanced & Expert Users	3	02-06-2007 01:13 PM
Replace 10th column with a new column--- Terriblly hurry	ahmedwaseem2000	Shell Programming and Scripting	2	09-06-2005 02:10 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:


	Powered by