Uniq on certain fields

•

What is DaniWeb IT Discussion Community?

You're currently browsing the Shell Scripting section within the Software Development category of DaniWeb, a massive community of 375,165 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,344 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our Shell Scripting advertiser:

Thread Tools Display Modes

Views: 434 | Replies: 2

•

Join Date: Mar 2008

Posts: 19

Reputation: sjgriffiths is an unknown quantity at this point

Rep Power: 1

Solved Threads: 0

sjgriffiths sjgriffiths is offline

Offline

Newbie Poster

Uniq on certain fields

May 9th, 2008

I have the following file

1928282,Stephen LTD,31280938,L34
3128398,Stephen LTD,84327489,L34

I want to uniq on fields 2 & 4, the fields are comma seperated

I cant figure out how to do this....any ideas? im pretty sure uniq does not support this

•

Join Date: Feb 2007

Posts: 49

Reputation: radoulov is an unknown quantity at this point

Rep Power: 2

Solved Threads: 4

radoulov

Offline

Light Poster

Re: Uniq on certain fields

May 9th, 2008

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

Help with Code Tags

(Toggle Plain Text)

awk -F, '!x[$2,$4]++'  input

•

Join Date: Oct 2007

Posts: 247

Reputation: eggi is on a distinguished road

Rep Power: 1

Solved Threads: 26

eggi

Offline

Posting Whiz in Training

Re: Uniq on certain fields

May 9th, 2008

You can also use the -u flag to sort, which can pick out fields:

sort -t, -u -k2,2 -k4,4

Best wishes,

Mike

Linux and Unix Tips, Tricks and Individual Advice - The Linux and Unix Menagerie!
------------------------------------------------------------------------
Having trouble passing cert exams? Check out How To Pass Any Computer Certification Test!