On Thu, Feb 17, 2011 at 02:40:42PM -0000, Ted Harding wrote:
On 17-Feb-11 13:30:53, Brett Parker wrote:
Should work. Note that's entirely untested and may eat your cat though.
It will eat the cat. There needs to be a pipe into a further 'sed' to undo the reversal of dd/mm/yyyy to yyyy/mm/dd:
sed -e 's#:([0-9][0-9])/([0-9][0-9])/([0-9][0-9][0-9][0-9]):#:\3-\2-\1:#' file | sort -d ":" -k 2 | sed -e 's#:([0-9][0-9])/([0-9][0-9])/([0-9][0-9][0-9][0-9]):#:\3-\2-\1:#'
Thanks both of you for your helpful input.
Richard