multiple replacements and sorting by most recent date

Alias   UID

AAbad   antonino-19895784
AAbadilla       albert-20059875
AAbeid  alaa-20015842
AAbraham2       anson-20063684
AAbyzov andrij-20089578
aacunzo antonio-19843587
AAdeogun        adegoke-19973584


aabad   2005/03/11
aabad   2008/03/16
aabad   2008/03/22
aabadilla       2008/03/03
aabadilla       2008/03/11
aabadilla       2007/04/02
aabadilla       2007/04/03
aabadilla       2008/03/24
aabeid  2008/04/01
aabeid  2008/03/15
aabeid  2008/01/24
aabraham2       2008/03/25
aabraham2       2008/02/15
aabraham2       2007/08/11
aabyzov 2007/03/26
aabyzov 200/05/11
aabyzov 2008/03/15
aacunzo 2008/03/04
aacunzo 2007/03/14
aacunzo 2008/04/30
aadeogun        2007/03/23
aadeogun        2008/04/21


I need use the first file to replace the users Alias that is in the second file the the UID that is in the first file.

Exaple for

replace
aabad   2005/03/11
with
antonino-19895784      2005/03/11


Then I need to sort out each user from the new file and only get the line for each user for the most recent date.

I can do this using a few users at a time but not sure how to do this for all of them without having to do only a few at a time.


Thanks for any help on this.
Start Free Trial