Not sure how to use diff and comm for my problem

InfoSeeker · #1 (**permalink**) 03-07-2009

Hello,
Apologies if this question has been repeated before, but I am getting myself confused even more as I scan the posts!

I have two files, file1 is a column:
1dlwa_
1s69a_
1idra_
1ngka_

And file2 has three columns (columns seperated by tabs):
1dlw a_ A
1uvy a_ A
1dly a_ A
1uvx a_ A
1s69 a_ A

I want to only extract from file2 those rows where the first & second column concatenated together matches the first column of file1. In this example above, I would only want to see:
1dlw a_ A
1s69 a_ A

And I want to save these in a new file, file3. How would I use diff, comm, or any combination of those to do it?
Thank you in advance for your help!
InfoSeeker

Franklin52 · #2 (**permalink**) 03-07-2009

Use nawk or /usr/xpg4/bin/awk on Solaris if you get errors:

Code:

awk 'NR==FNR{a[$0];next} $1$2 in a' file1 file2

Regards

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
problem with using comm	jathin12	Shell Programming and Scripting	4	02-27-2009 07:47 AM
Problem in using diff	ragavhere	Shell Programming and Scripting	6	04-19-2008 09:56 AM
getting problem in my code:::: plz help...(multithreaded appn with serial comm.)	arunchaudhary19	High Level Programming	0	10-29-2007 09:38 AM
getting problem in my code:::: plz help...(multithreaded appn with serial comm.)	arunchaudhary19	Linux	0	10-26-2007 06:24 AM
Diff command problem	gvsreddy_539	Shell Programming and Scripting	4	09-30-2007 08:36 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: