Sorting strings with orthographic accent (spanish)

[imcarlosdev]

Plugin is working very well but there is an issue with accents in spanish, when i sort the table with this content:

A
B
C
D
E
F
G
É <---------- This character must be after D letter but when i sort his position is at last of the rows.

[Mottie]

Hi @choquo!

Tablesorter includes a sortLocaleCompare option which uses localeCompare without any options to sort the content; but it doesn't work in this case.

What you'll need to do is create a parser to remove the accents (demo).

// Use to replace combining diacritics
var regex = /[\u0300-\u036f]/g;

$.tablesorter.addParser({
  id: 'diacritic',
  is: function() {
    return false;
  },
  format: function(s) {
    // .normalize() is only supported in newer browsers
    return s.normalize('NFKD').replace(/[\u0300-\u036f]/g, '');
  },
  type: 'text'
})

$('table').tablesorter({
  headers: {
    0: {
      sorter: 'diacritic'
    }
  }
});

This method still isn't ideal as it strips the diacritics instead of ordering them as they should be within the alphabet. To accomplish this, you'll need to use my fork of tablesorter along with Sugar.js' sorting algorithm (demo).

[imcarlosdev]

Thanks for your help @Mottie