date sorting

UNIX for Beginners Q & A UNIX for Dummies Questions & Answers
1

Hi at all,
I have to sort a log file on timestamp field. That's field is the third!

a log file sample.....

1|EVTVOD-1-20060709_000614|2006/07/09-0:11:23|0.3.8
1|EVTVOD-1-20060709_000614|2006/07/09-0:11:16|0.3.8
1|EVTVOD-1-20060709_000614|2006/07/09-0:11:20|0.3.8
1|EVTVOD-1-20060709_000614|2006/07/09-0:11:29|0.3.8
1|EVTVOD-1-20060709_000614|2006/07/09-0:11:1|0.3.8
1|EVTVOD-1-20060709_000614|2006/07/09-0:11:17|0.3.8

Fixing this command .....
cut -d \| -f1,2,3,4 pippo |sort -k 3n,3n | more

1|EVTVOD-1-20060709_000614|2006/07/09-0:11:16|0.3.8
1|EVTVOD-1-20060709_000614|2006/07/09-0:11:17|0.3.8
1|EVTVOD-1-20060709_000614|2006/07/09-0:11:1|0.3.8
1|EVTVOD-1-20060709_000614|2006/07/09-0:11:20|0.3.8
1|EVTVOD-1-20060709_000614|2006/07/09-0:11:23|0.3.8
1|EVTVOD-1-20060709_000614|2006/07/09-0:11:29|0.3.8

You note that third row is in wrong place (should be the first one)
How can solve this problem?

thanx

2 
nawk -F'|' -v OFS='|' '{tmp=$3; gsub("[-/:]", "", tmp); print tmp, $0}' pippo | sort -k 1n,1n | cut -d'|' -f2-
3

$ echo "1|EVTVOD-1-20060709_000614|2006/07/09-0:11:1|0.3.8" | sed -e 's/:\(.\)|/:\10|/' -e 's/-\(.\):/-0\1:/'
1|EVTVOD-1-20060709_000614|2006/07/09-00:11:10|0.3.8

This must help (at first)

4

Thanks at all!!!

I've solved my problem!