How to uniq third field in a file

babycakes · #1 (**permalink**) 01-31-2008

Hi ;

I have a question regarding the uniq command in unix

How do I uniq 3rd field in a file ?

original file :
zoom coord 39 18652 39 18652
zoom coord 39 18653 39 18653
zoom coord 39 18818 39 18818
zoom coord 39 18840 39 18840
zoom coord 41 15096 41 15096
zoom coord 41 15261 41 15261
zoom coord 41 15283 41 15283
zoom coord 53 16385 53 16385
zoom coord 53 16406 53 16406

desire output
zoom coord 39 18652 39 18652
zoom coord 41 15096 41 15096
zoom coord 53 16385 53 16385

Thanks

Yogesh Sawant · #2 (**permalink**) 02-01-2008

try this:

Code:

awk '{ if (! third_col[$3]) print $0;  third_col[$3]++; }' file

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Uniq using only the first field	Digby	UNIX for Dummies Questions & Answers	8	01-16-2008 06:25 AM
compare two col from 2 files, and output uniq from file 1	pp56825	Shell Programming and Scripting	2	01-10-2008 11:10 AM
select last field from a file	kykyboss	Shell Programming and Scripting	3	11-14-2006 10:15 AM
inserting uniq sequential numbers at the start of the file	jingi1234	UNIX for Dummies Questions & Answers	7	11-19-2005 06:42 PM
Append a field to the end of each line of a file based on searching another file.	ultimate	Shell Programming and Scripting	2	03-29-2005 10:21 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