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!

Register Log in
  • Congratulations Rhinorhino 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

TSch

Technical User
Joined
Jul 12, 2001
Messages
557
Location
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
 
Sort by date Sort by votes
Use sort and then uniq commands.

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


 
Upvote 0 Downvote
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.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

EdLentz
  • Locked
  • Question Question
How can I escape $1 and && in a SED command
Replies
1
Views
770
feherke
feherke
keerthi2016
  • Locked
  • Question Question
fetch all records from table dbi
Replies
0
Views
500
keerthi2016
keerthi2016
BauV
  • Locked
  • Question Question
Replace accent character "é" with "e"
Replies
9
Views
2K
mikrom
mikrom
pax94
  • Locked
  • Question Question
Script automating dynamic queries in a remote host
Replies
0
Views
494
pax94
pax94
admoore
  • Locked
  • Question Question
sed substitution within bash script with mixed quotes
Replies
1
Views
675
feherke
feherke

Part and Inventory Search

Sponsor

Back
Top