Re^4: sort csv file on "date" column

ok... I wanted to know what the numbers 6, [2,0,1] actually are. It he
+lps me to customize the algorithm you provided if the date field is i
+n other column.

~Manjunath
[download]

Comment on Re^4: sort csv file on "date" column Download Code

Replies are listed 'Best First'.
Re^5: sort csv file on "date" column by jwkrahn (Abbot) on Apr 26, 2009 at 23:30 UTC
In your CSV file the date is in the month-day-year order. The regular expression captures those numbers using parentheses and returns a list of those three numbers in month-day-year order. The list of numbers is rearranged using a list slice so that the year is moved to the front of the list. So the original order of month-day-year (0,1,2) is changed to year-month-day (2,0,1). The date format used has every field as a two digit number so the combination of the year, month and day fields is a string 6 characters long.	[reply]

Replies are listed 'Best First'.

Re^5: sort csv file on "date" column
by jwkrahn (Abbot) on Apr 26, 2009 at 23:30 UTC

In your CSV file the date is in the month-day-year order. The regular expression captures those numbers using parentheses and returns a list of those three numbers in month-day-year order. The list of numbers is rearranged using a list slice so that the year is moved to the front of the list. So the original order of month-day-year (0,1,2) is changed to year-month-day (2,0,1).

The date format used has every field as a two digit number so the combination of the year, month and day fields is a string 6 characters long.

[reply]