Merge files of differrent size with one field common in both files using awk

shashi1982 · #1 (**permalink**) 03-03-2009

hi,

i am facing a problem in merging two files using awk,
the problem is as stated below,

file1:

A|B|C|D|E|F|G|H|I|1
M|N|O|P|Q|R|S|T|U|2
AA|BB|CC|DD|EE|FF|GG|HH|II|1
....
....
....

file2 :

1|Mn|op|qr

result file
A|B|C|Mn|op|qr|D|E|F|G|H|I|1
M|N|O|P|Q|R|S|T|U|2
AA|BB|CC|Mn|op|qr||DD|EE|FF|GG|HH|II|1

file1 can have more than 10,000 records
file2 can have only 1000 records,

The field's 2,3,4 from second file (file2) should be read and should be inserted into filed's 4,5,6 in first file (file1) where lastfiled of "ile1 == first field of file2"

please give me the solution.......
Thanks

vgersh99 · #2 (**permalink**) 03-03-2009

There are plenty of similar threads - please use the 'Search' function.

Franklin52 · #3 (**permalink**) 03-03-2009

To be more precisely, search for NR==FNR.

Regards

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
list common name files	mazhar99	UNIX for Dummies Questions & Answers	4	08-18-2008 11:21 PM
Help with complex merg of files with common field	gugs	Shell Programming and Scripting	18	07-16-2008 05:04 AM
merge based on common, awk help	jkl_jkl	Shell Programming and Scripting	3	03-17-2008 07:13 AM
bash script working for small size files but not for big size files.	davidpreml	Shell Programming and Scripting	1	11-01-2006 11:06 AM
Get un common numbers from two files	jingi1234	UNIX for Dummies Questions & Answers	3	10-19-2005 08:32 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