Adding loads of columns

zajtat · #1 (**permalink**) 4 Weeks Ago

Hi All,

I've got file1 like this:

Code:

aaa bbb ccc
ddd eee fff
ggg hhh kkk
ppp mmm nnn

and file 2 like this:

Code:

aaa qqq www
ddd fff ggg
ggg sss zzz
ppp vvv yyy

and file 3 like this:

Code:

aaa 
ggg
ppp

I need to match the first column of file3 and file1, then add the rest of the file 1 to the file3. The result would be:

Code:

aaa bbb ccc
ggg hhh kkk
ppp mmm nnn

Then again match the first column and add the rest of the file2. The result would be:

Code:

aaa bbb ccc qqq www
ggg hhh kkk sss zzz
ppp mmm nnn vvv yyy

I've got many files and each of them has matching patterns in first column and then loads of columns that I need to all add into one file. Hope this is not too confusing :-)

Any help will be GREATLY appreciated! It doesn't need to be a big loop or anything, I don't mind if someone could help me with the first step only...

Many thanks!

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Adding columns of two files	chandra321	Shell Programming and Scripting	7	05-06-2009 01:11 PM
adding columns	Kelam_Magnus	Shell Programming and Scripting	12	02-10-2009 10:56 AM
awk adding columns from different files	dsstamps	Shell Programming and Scripting	1	09-16-2008 06:36 PM
Adding columns to a file	figaro	UNIX for Dummies Questions & Answers	5	07-21-2008 02:50 AM
Adding columns in csv	chachabronson	UNIX for Advanced & Expert Users	7	06-27-2008 10:06 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 Switch to Hybrid Mode Threaded Mode	Rate This Thread:


	Powered by