Data managing problem

manorhce has asked for the wisdom of the Perl Monks concerning the following question:

Hi Can you please help on this, I have data like below

1/2/2013     cgoo     nreuiheru
1/4/2013     doow    reiqrqueih
1/5/2013     hellio    ruieqrhfuepqh
1/20/2013    cgoo    3rhquh4ureyh
1/30/2013    yetil     jerqohgqrij
2/13/2013    hellio   rueqipheruh
2/14/2013    cgoo    wehrig4r74378
[download]

but I need the data like

1/4/2013     doow    reiqrqueih
1/30/2013    yetil     jerqohgqrij
2/13/2013    hellio   rueqipheruh
2/14/2013    cgoo    wehrig4r74378
[download]

basically I need the data with respect to second field if it is duplicate then pick the last duplicate

Please let me know if you have anything unclear

Back to Seekers of Perl Wisdom