I need help in a SORT related request. Please see below:
The input file is has records like this:
Code: Select all
XXXX8558011
XXXX8558012
XXXX8558013
YYYY9559011
YYYY9559012
YYYY9559013
ZZZZ7557011
ZZZZ7557012
ZZZZ7557013
I want to generate an output like this. In which I wnat to keep only the latest record.
Code: Select all
XXXX8558013
YYYY9559013
ZZZZ7557013
So, from the series:
Code: Select all
XXXX8558011
XXXX8558012
XXXX8558013
Code: Select all
XXXX8558013