[jQuery] Re: Tablesorter dateFormat

2007-12-20 Thread Jay Fallon 

Thanks Christian!! That worked out great. Thanks again for your time
and the plugin, of course.

On Dec 20, 3:02 am, "Christian Bach" <[EMAIL PROTECTED]>
wrote:
> Hi Jay,
>
> There was a small bug in the parser.
>
> This works as expected:
>
> $.tablesorter.addParser({
> // set a unique id
> id: 'dates',
> is: function(s) {
> // return false so this parser is not auto detected
> return false;
> },
> format: function(s) {
> // split
> var a = s.split('-');
> // get month num
> a[1] = this.getMonth(a[1]);
> // glue and return a new date
> return new Date(a.reverse().join("/")).getTime();
> },
> getMonth: function(s) {
> var m =
> ['jan','feb','mar','apr','may','jun','jul','aug','sep','oct','nov','dec']
> var l = m.length;
> for(var i=0; i < l; i++) {
> if(m[i] == s.toLowerCase()) {
> return (i+1);
> }
> }
> },
> // set type, either numeric or text
> type: 'numeric'
>
> });
>
> /Christian
>
> 2007/12/19, Jay Fallon <[EMAIL PROTECTED]>:
>
>
>
> > Hi Christian, thanks for the follow up,
>
> > I implemented the script as you described and it's still not sorting
> > correctly:
>
> >http://jayfallon.net/tablesorter/tablesorter.html
>
> > On Dec 19, 1:21 pm, "Christian Bach" <[EMAIL PROTECTED]>
> > wrote:
> > > Hi Jay,
>
> > > This will solve your problem:
>
> > > // add parser through the tablesorter addParser method
> > > $.tablesorter.addParser({
> > >// set a unique id
> > >id: 'dates',
> > >is: function(s) {
> > >// return false so this parser is not auto detected
> > >return false;
> > >},
> > >format: function(s) {
> > > // split
> > > var a = s.split('-');
> > > // get month num
> > > a[1] = this.getMonth(a[1]);
> > > // glue and return a new date
> > > return new Date(a.join("/")).getTime();
> > >},
> > >getMonth: function(s) {
> > > var m =
>
> > ['jan','feb','mar','apr','may','jun','jul','aug','sep','oct','nov','dec']
> > > var l = m.length;
> > > for(var i=0; i < l; i++) {
> > > if(m[i] == s.toLowerCase()) {
> > > return (i+1);
> > > }
> > > }
> > >},
> > >// set type, either numeric or text
> > >type: 'numeric'
>
> > > });
>
> > > /christian
>
> > > 2007/12/18, Jay Fallon <[EMAIL PROTECTED]>:
>
> > > > It's easy to write a parser to convert the months to a sortable value,
> > > > but the days and years are trickier. the current code is as follows:
>
> > > > // add parser through the tablesorter addParser method
> > > > $.tablesorter.addParser({
> > > > // set a unique id
> > > > id: 'dates',
> > > > is: function(s) {
> > > > // return false so this parser is not
> > auto
> > > > detected
> > > > return false;
> > > > },
> > > > format: function(s) {
> > > > // format your data for normalization
> > > > return s.toLowerCase
> > > > ().replace(/dec/,12).replace(/nov/,
> > > > 11).replace(/oct/,10).replace(/sep/,09).replace(/aug/,08).replace(/
> > > > jul/,07).replace(/jun/,06).replace(/may/,05).replace(/apr/,
> > > > 04).replace(/mar/,03).replace(/feb/,02).replace(/jan/,01);
> > > > },
> > > > // set type, either numeric or text
> > > > type: 'numeric'
> > > > });
>
> > > > $(function() {
> > > > $.tablesorter.defaults.widgets = ['zebra'];
> > > > $("#announcements").tablesorter({
> > > > headers: {
> > > > 0: {sorter:'dates'},1:
> > > > {sorter:false},2: {sorter:false},3:
> > > > {sorter:false}
> > > > }
> > > > });
> > > > });
>
> > > > On Dec 18, 2:06 pm, Jay Fallon <[EMAIL PROTECTED]> wrote:
> > > > > I need to sort a table based on the date format: 10-Dec-2007. Does
> > > > > anyone know if this is possible with Tablesorter?
>
> > > > > I've tried us, uk & iso to no avail.
>
> > > > > Thanks, Jay

[jQuery] Re: Tablesorter dateFormat

2007-12-20 Thread Christian Bach 
Hi Jay,

There was a small bug in the parser.

This works as expected:

$.tablesorter.addParser({
// set a unique id
id: 'dates',
is: function(s) {
// return false so this parser is not auto detected
return false;
},
format: function(s) {
// split
var a = s.split('-');
// get month num
a[1] = this.getMonth(a[1]);
// glue and return a new date
return new Date(a.reverse().join("/")).getTime();
},
getMonth: function(s) {
var m =
['jan','feb','mar','apr','may','jun','jul','aug','sep','oct','nov','dec']
var l = m.length;
for(var i=0; i < l; i++) {
if(m[i] == s.toLowerCase()) {
return (i+1);
}
}
},
// set type, either numeric or text
type: 'numeric'
});


/Christian

2007/12/19, Jay Fallon <[EMAIL PROTECTED]>:
>
>
> Hi Christian, thanks for the follow up,
>
> I implemented the script as you described and it's still not sorting
> correctly:
>
> http://jayfallon.net/tablesorter/tablesorter.html
>
> On Dec 19, 1:21 pm, "Christian Bach" <[EMAIL PROTECTED]>
> wrote:
> > Hi Jay,
> >
> > This will solve your problem:
> >
> > // add parser through the tablesorter addParser method
> > $.tablesorter.addParser({
> >// set a unique id
> >id: 'dates',
> >is: function(s) {
> >// return false so this parser is not auto detected
> >return false;
> >},
> >format: function(s) {
> > // split
> > var a = s.split('-');
> > // get month num
> > a[1] = this.getMonth(a[1]);
> > // glue and return a new date
> > return new Date(a.join("/")).getTime();
> >},
> >getMonth: function(s) {
> > var m =
> >
> ['jan','feb','mar','apr','may','jun','jul','aug','sep','oct','nov','dec']
> > var l = m.length;
> > for(var i=0; i < l; i++) {
> > if(m[i] == s.toLowerCase()) {
> > return (i+1);
> > }
> > }
> >},
> >// set type, either numeric or text
> >type: 'numeric'
> >
> > });
> >
> > /christian
> >
> > 2007/12/18, Jay Fallon <[EMAIL PROTECTED]>:
> >
> >
> >
> > > It's easy to write a parser to convert the months to a sortable value,
> > > but the days and years are trickier. the current code is as follows:
> >
> > > // add parser through the tablesorter addParser method
> > > $.tablesorter.addParser({
> > > // set a unique id
> > > id: 'dates',
> > > is: function(s) {
> > > // return false so this parser is not
> auto
> > > detected
> > > return false;
> > > },
> > > format: function(s) {
> > > // format your data for normalization
> > > return s.toLowerCase
> > > ().replace(/dec/,12).replace(/nov/,
> > > 11).replace(/oct/,10).replace(/sep/,09).replace(/aug/,08).replace(/
> > > jul/,07).replace(/jun/,06).replace(/may/,05).replace(/apr/,
> > > 04).replace(/mar/,03).replace(/feb/,02).replace(/jan/,01);
> > > },
> > > // set type, either numeric or text
> > > type: 'numeric'
> > > });
> >
> > > $(function() {
> > > $.tablesorter.defaults.widgets = ['zebra'];
> > > $("#announcements").tablesorter({
> > > headers: {
> > > 0: {sorter:'dates'},1:
> > > {sorter:false},2: {sorter:false},3:
> > > {sorter:false}
> > > }
> > > });
> > > });
> >
> > > On Dec 18, 2:06 pm, Jay Fallon <[EMAIL PROTECTED]> wrote:
> > > > I need to sort a table based on the date format: 10-Dec-2007. Does
> > > > anyone know if this is possible with Tablesorter?
> >
> > > > I've tried us, uk & iso to no avail.
> >
> > > > Thanks, Jay
>

[jQuery] Re: Tablesorter dateFormat

2007-12-19 Thread Jay Fallon 

Hi Christian, thanks for the follow up,

I implemented the script as you described and it's still not sorting
correctly:

http://jayfallon.net/tablesorter/tablesorter.html

On Dec 19, 1:21 pm, "Christian Bach" <[EMAIL PROTECTED]>
wrote:
> Hi Jay,
>
> This will solve your problem:
>
> // add parser through the tablesorter addParser method
> $.tablesorter.addParser({
>// set a unique id
>id: 'dates',
>is: function(s) {
>// return false so this parser is not auto detected
>return false;
>},
>format: function(s) {
> // split
> var a = s.split('-');
> // get month num
> a[1] = this.getMonth(a[1]);
> // glue and return a new date
> return new Date(a.join("/")).getTime();
>},
>getMonth: function(s) {
> var m =
> ['jan','feb','mar','apr','may','jun','jul','aug','sep','oct','nov','dec']
> var l = m.length;
> for(var i=0; i < l; i++) {
> if(m[i] == s.toLowerCase()) {
> return (i+1);
> }
> }
>},
>// set type, either numeric or text
>type: 'numeric'
>
> });
>
> /christian
>
> 2007/12/18, Jay Fallon <[EMAIL PROTECTED]>:
>
>
>
> > It's easy to write a parser to convert the months to a sortable value,
> > but the days and years are trickier. the current code is as follows:
>
> > // add parser through the tablesorter addParser method
> > $.tablesorter.addParser({
> > // set a unique id
> > id: 'dates',
> > is: function(s) {
> > // return false so this parser is not auto
> > detected
> > return false;
> > },
> > format: function(s) {
> > // format your data for normalization
> > return s.toLowerCase
> > ().replace(/dec/,12).replace(/nov/,
> > 11).replace(/oct/,10).replace(/sep/,09).replace(/aug/,08).replace(/
> > jul/,07).replace(/jun/,06).replace(/may/,05).replace(/apr/,
> > 04).replace(/mar/,03).replace(/feb/,02).replace(/jan/,01);
> > },
> > // set type, either numeric or text
> > type: 'numeric'
> > });
>
> > $(function() {
> > $.tablesorter.defaults.widgets = ['zebra'];
> > $("#announcements").tablesorter({
> > headers: {
> > 0: {sorter:'dates'},1:
> > {sorter:false},2: {sorter:false},3:
> > {sorter:false}
> > }
> > });
> > });
>
> > On Dec 18, 2:06 pm, Jay Fallon <[EMAIL PROTECTED]> wrote:
> > > I need to sort a table based on the date format: 10-Dec-2007. Does
> > > anyone know if this is possible with Tablesorter?
>
> > > I've tried us, uk & iso to no avail.
>
> > > Thanks, Jay

[jQuery] Re: Tablesorter dateFormat

2007-12-19 Thread Christian Bach 
Hi Jay,

This will solve your problem:

// add parser through the tablesorter addParser method
$.tablesorter.addParser({
   // set a unique id
   id: 'dates',
   is: function(s) {
   // return false so this parser is not auto detected
   return false;
   },
   format: function(s) {
// split
var a = s.split('-');
// get month num
a[1] = this.getMonth(a[1]);
// glue and return a new date
return new Date(a.join("/")).getTime();
   },
   getMonth: function(s) {
var m =
['jan','feb','mar','apr','may','jun','jul','aug','sep','oct','nov','dec']
var l = m.length;
for(var i=0; i < l; i++) {
if(m[i] == s.toLowerCase()) {
return (i+1);
}
}
   },
   // set type, either numeric or text
   type: 'numeric'
});

/christian


2007/12/18, Jay Fallon <[EMAIL PROTECTED]>:
>
>
> It's easy to write a parser to convert the months to a sortable value,
> but the days and years are trickier. the current code is as follows:
>
> // add parser through the tablesorter addParser method
> $.tablesorter.addParser({
> // set a unique id
> id: 'dates',
> is: function(s) {
> // return false so this parser is not auto
> detected
> return false;
> },
> format: function(s) {
> // format your data for normalization
> return s.toLowerCase
> ().replace(/dec/,12).replace(/nov/,
> 11).replace(/oct/,10).replace(/sep/,09).replace(/aug/,08).replace(/
> jul/,07).replace(/jun/,06).replace(/may/,05).replace(/apr/,
> 04).replace(/mar/,03).replace(/feb/,02).replace(/jan/,01);
> },
> // set type, either numeric or text
> type: 'numeric'
> });
>
> $(function() {
> $.tablesorter.defaults.widgets = ['zebra'];
> $("#announcements").tablesorter({
> headers: {
> 0: {sorter:'dates'},1:
> {sorter:false},2: {sorter:false},3:
> {sorter:false}
> }
> });
> });
>
> On Dec 18, 2:06 pm, Jay Fallon <[EMAIL PROTECTED]> wrote:
> > I need to sort a table based on the date format: 10-Dec-2007. Does
> > anyone know if this is possible with Tablesorter?
> >
> > I've tried us, uk & iso to no avail.
> >
> > Thanks, Jay
>

[jQuery] Re: Tablesorter dateFormat

2007-12-18 Thread Jay Fallon 

It's easy to write a parser to convert the months to a sortable value,
but the days and years are trickier. the current code is as follows:

// add parser through the tablesorter addParser method
$.tablesorter.addParser({
// set a unique id
id: 'dates',
is: function(s) {
// return false so this parser is not auto 
detected
return false;
},
format: function(s) {
// format your data for normalization
return 
s.toLowerCase().replace(/dec/,12).replace(/nov/,
11).replace(/oct/,10).replace(/sep/,09).replace(/aug/,08).replace(/
jul/,07).replace(/jun/,06).replace(/may/,05).replace(/apr/,
04).replace(/mar/,03).replace(/feb/,02).replace(/jan/,01);
},
// set type, either numeric or text
type: 'numeric'
});

$(function() {
$.tablesorter.defaults.widgets = ['zebra'];
$("#announcements").tablesorter({
headers: {
0: {sorter:'dates'},1: 
{sorter:false},2: {sorter:false},3:
{sorter:false}
}
});
});

On Dec 18, 2:06 pm, Jay Fallon <[EMAIL PROTECTED]> wrote:
> I need to sort a table based on the date format: 10-Dec-2007. Does
> anyone know if this is possible with Tablesorter?
>
> I've tried us, uk & iso to no avail.
>
> Thanks, Jay