compare two col from 2 files, and output uniq from file 1

pp56825 · #1 (**permalink**) 01-09-2008

Hi,
I can't find how to achive such thing, please help.
I have try with uniq and comm but those command can't compare columns just whole lines,
I think awk will be the best but awk is magic for me as of now.

file a
a1~a2~a3~a4~a6~a7~a8

file b
b1~b2~b3~b4~b6~b7~b8

output 1:
compare columns 3 from files a and b
print all lines from file a where where column a3 is present in file b as b3
a1~a2~a3~a4~a6~a7~a8

Regards
Peter

sysgate · #2 (**permalink**) 01-10-2008

awk '{print $3}' file.name > new.file.name
then the same for the second file, but append the result, and then "uniq -d" which will print only the duplicates.

radoulov · #3 (**permalink**) 01-10-2008

Do you want this?

Code:

awk 'NR==FNR{x[$3];next}$3 in x' FS="~" fileB fileA

Use nawk or /usr/xpg4/bin/awk on Solaris.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
compare columns from seven files and print the output	smriti_shridhar	Shell Programming and Scripting	7	06-11-2008 12:22 AM
Compare 2 files and output result in pop up window	hongsh	UNIX for Dummies Questions & Answers	2	05-23-2008 09:50 AM
Compare 2 files and give uniq output	rauphelhunter	Shell Programming and Scripting	1	05-12-2008 04:47 PM
Compare 2 files for a single column and output differences	samit_9999	UNIX for Dummies Questions & Answers	1	04-23-2008 12:02 PM
compare 2 files, output dups to file	blt123	UNIX for Dummies Questions & Answers	2	07-15-2004 10:31 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:


	Powered by