Need Help Comparing two Files

awknerd · #1 (**permalink**) 08-31-2008

I really need help on creating a script that does the following:

I have one file (File 1) with lines in the following format:

Name.maf score1 score2

I have a second file (File 2) with lines in the following format:

label start end Name

What I need to do is compare File 1 and File 2. When the Name matches, then I need to add the "label, "start" and "end" column's value of File 2 to the 2nd, third and fourth column of File 1 to get

Output

Name.maf label start end score1 score2

The trick here too is that what needs to match is only the Name, not the entire Name.maf. e.g. hello.maf and hello would be Name matches.

Any help would be very much appreciated! Thanks!

Annihilannic · #2 (**permalink**) 09-01-2008

Try searching this site for 'NR==FNR' and you should see many posts with similar requirements.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Comparing two files	ragavhere	Shell Programming and Scripting	32	12-04-2008 01:24 PM
Comparing two txt files - pls help	jisha	Shell Programming and Scripting	5	01-23-2008 04:14 AM
Comparing two files..	padarthy	Shell Programming and Scripting	1	08-29-2007 08:01 AM
comparing shadow files with real files	terrym	UNIX for Advanced & Expert Users	4	02-09-2007 02:38 AM
comparing two files using awk.	jerome Sukumar	Shell Programming and Scripting	4	11-22-2006 06:27 AM

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: