Adding columns of two files

chandra321 · #1 (**permalink**) 04-05-2007

Hello everyone,

I have two files containing 6 columns and thousands of rows. I want to add them (i.e. first column of first file + first column of second file and so on) and print the output in a third file. Can you please help me.

Thanks a lot

vgersh99 · #2 (**permalink**) 04-05-2007

assuming your fields are 'space/tab' separated AND you want to produce one cell adding all rows in all the files for a gven column.

Code:

nawk '
   {
      for(i=1; i<= NF; i++)
         arr[i] += $i
      nf=NF
   }
   END {
      for(i=1; i<=nf; i++)
         printf("%s%s", arr[i], (i<nf) ? OFS : "\n") 
   }
' file1 file2

chandra321 · #3 (**permalink**) 04-05-2007

Thanks a lot for the help. But I am not sure I made myself clear. Suppose I have files A and B (shown below) with 2 rows and 3 columns -

I just want another file with the same dimensions, just adding the corresponding element in each file.

A
1 1 1
2 2 2

B
1 1 1
3 3 3

Output file C
2 2 2
5 5 5

Does this program do that?

Thanks a lot

chandra321 · #4 (**permalink**) 04-05-2007

I am sorry. I was not clear in my first post.

vgersh99 · #5 (**permalink**) 04-05-2007

Code:

nawk ' 
FNR==NR {
  for(i=1; i<=NF; i++)
    f1[FNR,i]=$i
  next
}
{
  for(i=1; i<=NF; i++)
    printf("%d%s", $i+f1[FNR,i], (i==NF) ? "\n" : FS);
}' fileA fileB

amon · #6 (**permalink**) 04-06-2007

cool work!!and usefull

chandra321 · #7 (**permalink**) 04-06-2007

Thanks a lot. It was really useful.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
adding columns	Kelam_Magnus	Shell Programming and Scripting	12	02-10-2009 10:56 AM
Adding columns to a file	figaro	UNIX for Dummies Questions & Answers	5	07-21-2008 01:50 AM
comparing files - adding/subtracting/formating columns	oabdalla	Shell Programming and Scripting	7	06-13-2008 03:20 AM
Perl: adding columns in CSV file with information in each	dolo21taf	Shell Programming and Scripting	1	03-05-2008 02:52 AM
Adding columns to excel files using Perl	dolo21taf	Shell Programming and Scripting	1	02-20-2008 07:13 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