Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Filter out columns with same value from a list

Status
Not open for further replies.

TSch

Technical User
Jul 12, 2001
557
0
0
DE
Hello again,

I'm facing the following Problem (AIX, ksh):

I got a list containing the following columns:

Code:
Filename;OrderNo;ModifyDateofFile

Now the challenge is to filter out all the entries with the same OrderNo and only keep the one with the latest ModifyDateofFile Timestamp ...

Any ideas how I can do this ?

Regards,
Thomas
 
Use sort and then uniq commands.

==================================
advanced cognitive capabilities and other marketing buzzwords explained with sarcastic simplicity


 
use sort -du

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.

Never mind this jesus character, stars had to die for me to live.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top