Addition problem

onlyroshni · #1 (**permalink**) 12-07-2007

Hello Seniors!!! I am trying to add to lines on a file which is delimited by character "|".

input.txt

Quote:

Line Count|0|0|173|1406|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|2 46|0|0|0|46|0|619
Line Count|1|5|0|0|0|0|0|0|0|0|0|33|12|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0| 0|0|0|0|0

Desired Output file should give simple addition.
output.txt

Quote:

Line Count|1|5|173|1406|0|0|0|0|0|0|0|33|12|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0 |246|0|0|0|46|0|619

Can some one provide me simple awk solution to this. M struggling to solve this using awk & for loop inside awk.

Thanks in advance.

gus2000 · #2 (**permalink**) 12-07-2007

You didn't say how many lines (records) there were, but this should work for any number of lines:

Code:

# echo "1|2|3|4|5
2|2|2|2|2" | awk '
{
  n=split($0,a,"|")
  for (i=1;i<=n;i++) { sum[i]=sum[i]+a[i] }
}END{
  for (i=1;i<n;i++) { printf "%d|",sum[i] }
  print sum[n]
}'

3|4|5|6|7

If you need to skip summing the first field (which you apparently do) then start "i=2" (both places), and then add "printf "%s|",a[1]" before the final "for" loop.

onlyroshni · #3 (**permalink**) 12-10-2007

Thanks this works for me. I have only 2 lines.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Unix addition ( Row wise)	gauravgoel	Shell Programming and Scripting	3	05-17-2007 04:27 AM
linux setup and addition config	chlawren	Linux	3	02-05-2007 11:10 AM
floating point addition	ravi raj kumar	Shell Programming and Scripting	8	12-22-2006 02:47 AM
Addition of numbers in unix	asinha63	Shell Programming and Scripting	3	03-14-2006 12:38 PM
suggested addition to forum rules	PxT	Post Here to Contact Site Administrators and Moderators	1	10-31-2001 09:51 PM

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