Eliminate partially duplicate lines by column and keep the last one

Question

I have a file that looks like this:

2011-03-21 name001 line1 2011-03-21 name002 line2 2011-03-21 name003 line3 2011-03-22 name002 line4 2011-03-22 name001 line5 

for each name, I only want its last appearance. So, I expect the result to be:

2011-03-21 name003 line3 2011-03-22 name002 line4 2011-03-22 name001 line5 

Could someone give me a solution with bash/awk/sed?

Answer 1

This code get uniq lines by second field but from the end of file or text (like in your result example)

tac temp.txt | sort -k2,2 -r -u