Combine file using shell script

justbow · #1 (**permalink**) 02-10-2009

Hi,

i have 2 file

1.txt :

Quote:

1,a
2,b
3,c
5,e

2.txt

Quote:

1,pp
2,rr
3,hh
5,
7,oo
8,zz

then i would the result become :

Quote:

1,a,pp
2,b,rr
3,c,hh
5,e,
7,,oo
8,,zz

can anybody help me..

regards,

angheloko · #2 (**permalink**) 02-10-2009

Hope this helps:

Code:

cut -f1 -d"," file1 > keys
cut -f1 -d"," file2 >> keys
sort keys | uniq -ud | while read X; do
	echo "$X,"`sed -n "/^$X/p" file1 | cut -f2 -d","`","`sed -n "/^$X/p" file2 | cut -f2 -d","`
done

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
combine 3 excel files using shell.	radhika	Shell Programming and Scripting	11	05-06-2009 06:18 AM
help with a script that will combine two separate scripts for solaris and aix	solaix14	Shell Programming and Scripting	7	10-07-2008 01:49 AM
combine multiple .xl file	bikas_jena	Shell Programming and Scripting	4	12-11-2007 04:12 PM
Reading file names from a file and executing the relative file from shell script	anushilrai	Shell Programming and Scripting	4	03-10-2006 05:25 AM
Combine file	sabercats	Shell Programming and Scripting	3	03-02-2006 05:14 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: