|No such thing as a small change|
Sorting dates with the Schwartzian Transformby Wobbel (Acolyte)
|on Aug 03, 2011 at 13:28 UTC||Need Help??|
Wobbel has asked for the
wisdom of the Perl Monks concerning the following question:
The sorting on 4 columns of a 40 column textfile with the Schwartzian Transform works fine, except the date column.
It's in DD-MM-YYYY format and alfabetically/numerically handled as a string.
Do I have to convert this column before the ST to a number, sort it during the ST as a number, and after the ST convert it back to the DD-MM-YYYY format?
Or is there an elegant solution within the ST possible?
I think, the first option will harm the performance...
Any expert advice is very welcome.