Ignore Keywords in Sorting

Hi,

thanks for your post, and sorry for the trouble.

This is not possible by default, but you can try to add this by adding a new sorting algorithm.
As a starting point, I suggest to install the “Sorting Plugins” Extension from http://tablepress.org/extensions/datatables-sorting-plugins/
Then, append this to BOTH JavaScript files in the Extension:

jQuery.extend( jQuery.fn.dataTableExt.oSort, {
    "anti-the-pre": function ( a ) {
        return a.replace(/^the /i, "").replace(/^an /i, "").replace(/^a /i, "");
    },
     "anti-the-asc": function ( a, b ) {
        return ((a < b) ? -1 : ((a > b) ? 1 : 0));
    },
     "anti-the-desc": function ( a, b ) {
        return ((a < b) ? 1 : ((a > b) ? -1 : 0));
    }
} );

Finally, add something like this to the “Custom Commands” textfield on the table’s “Edit” screen:

"aoColumnDefs": [ { "sType": "anti-the", "aTargets": [ 2, 3 ] } ]

The “2, 3” indicate that this sorting shall then apply to the third and fourth columns (counting starts with 0), so adjust that as necessary.

Regards,
Tobias

Hi,

no problem, you are very welcome! 🙂 If there’s a problem, just let me know.

Best wishes,
Tobias

P.S.: In case you haven’t, please rate TablePress here in the plugin directory. Thanks!