merging few columns of two text files to a new file

kolvi · #1 (**permalink**) 09-14-2005

hi

i need to select a few columns of two txt files and write it to a new file. there is one common field for both of these files.

plz help me in this

thanks in advance

shihabvk · #2 (**permalink**) 09-14-2005

Hi,
Can you explain with an example?

Shihab

kolvi · #3 (**permalink**) 09-14-2005

i have 2 files with columns like :

file 1

x1,y1, z1

file 2
a1,b1,x1,c1,d1,e1

now i want the output as

b1,y1,c1,d1 for all the x1 of file1 in x1 of file2

i want to new file to be a merger of file1 and file 2 as explained above

aigles · #4 (**permalink**) 09-14-2005

You can use the join command.
The two files (file1 and file2) must be sorted on the common field x1.

Code:

join -t , -1 1 -2 3 -o file1 file2 > file 3

-t , : , is field separator
-1 1 : join files using field 1 in file 1
-2 3 : join files using field 2 in file 2
-o 2.2,1.2,2.4,2.5 : list of resulting files (filenumber.field,...)

Jean-Pierre

kolvi · #5 (**permalink**) 09-15-2005

Thanks Jean, it worked prefect!!!!

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
how to extract columns from a text file	ihot	Shell Programming and Scripting	16	05-05-2008 11:33 PM
merging text files	code19	Shell Programming and Scripting	8	02-13-2008 08:13 AM
Extract text in 2 columns of output file.	Danish Shakil	Shell Programming and Scripting	2	10-19-2007 10:03 AM
Extracting columns from different files for later merging	kingkong	UNIX for Dummies Questions & Answers	2	11-23-2005 03:21 AM
searching text files on specific columns for duplicates	Gerry405	UNIX for Dummies Questions & Answers	2	08-18-2005 10:51 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