4

Get lines with maximum values in the column using awk, uniq and sort

view full story
linux-howto

http://unix.stackexchange.com – I have a file with next format 2011-12-01 user1 access1 2011-12-01 user1 access2 2011-12-01 user2 access2 2011-12-01 user4 access2 2011-12-02 user1 access1 2012-01-01 user3 access1 2012-01-01 user4 access2 I would like to have an output that for every user shows the last date, so 2011-12-02 user1 access1 2011-12-01 user1 access2 2011-12-01 user2 access2 2012-01-01 user3 access1 2012-01-01 user4 access2 I tried something like this: less myfile.txt | sort -k1r | uniq -f 1 | sort -b -k1 but it isn't seems to work right. Thank you for help! (HowTos)