I've been working with the Tablesorter plugin recently and had to do something similar. You can make your own textExtraction function and use it to extract an organize the data how you want. In your case I'd probably do something where you parse out just the numbers, zero pad them, concat together and return a parseInt on it. The biggest problem I had was youc an only specify 1 textExtraction function to use so I added an attribute to the table cells to specify the kind of data then my textExtraction function decided what to do based on that.
Example: $.tablesorter.defaults.textExtraction = function (node) { var r, v; try { v = node.attr("textExtraction"); } catch(e) { v = "none"; } switch (v) { case "specialdate": //do your stuff and set it to v break; default: v = node.innerHTML; break; } return v; }; On May 13, 1:16 pm, Seth - TA <[EMAIL PROTECTED]> wrote: > [Tried posting this, but never saw it go through. Sorry if it > duplicates] > > I am having a couple issues with how to sort a few of my fields. > > The first, and I think most difficult is I have a field which holds > the value of "Empty" or lists state abbreviations. What I'd like it to > do is have "Empty" be grouped together and then sort the state > abbreviations in alpha. I tried the grades demo, but with no success. > > The second is I have an ID field which is constructed by the year and > then a sequential number. > Example - 2008 - 1, 2008 - 2, 2008 - 3, etc. > The problem is that when sorted it sorts like this... > 2008 - 90, 2008 - 9, 2008 - 89 > > It does see the 9 as coming after 8 and before 10, but between 90 and > 89. Help with either one is greatly appreciated. > > Seth