key problems with accent (spanish)

nestoronald

Hello, I have problems with accented words filter. Example: I have a table with data:
1. Juan Perez
2. Jose Pérez
3. Pedro Pèrez.
Write "Perez" and I only filter: 1. Juan Perez. I want to filter all the "Perez" with or without accent.

allan

This is definitely a bit of a problem at the moment. The problem basically is that DataTables uses straight string matching, and `é !== e` etc - hence why it doesn't match. What I think would probably be needed is a filtering formatter, which is certainly possible (at least in 1.10, I'm not sure that it is in 1.9...) but then, you need to consider the case when your user does search for `é` rather than `e` . It would be relatively simple to replace all accented characters with their non-accented counterparts, but it would mean that filtering with accented characters wouldn't work...

Here is an example of how you could modify the built-in search string formatter in 1.10 to remove the accents and filter only on non-accented characters.

[code]
$.fn.DataTable.ext.type.search.string = function ( data ) {
return ! data ?
'' :
typeof data === 'string' ?
data
.replace( /\n/g, " " )
.replace( /é/g, 'e' )
.replace( /ê/g, 'e' )
.replace( /è/g, 'e' ) :
data;
}
[/code]

1.10 is pre-beta, but it is available as the nightly on http://datatables.net/download .

Let me know how you get on with it!

Allan

allan

[code]
$.fn.DataTable.ext.type.search.string = function ( data ) {
return ! data ?
'' :
typeof data === 'string' ?
data
.replace( /\n/g, " " )
.replace( /[éêè]/g, 'e' ) :
data;
}
[/code]

would be more efficient thinking about it. Obviously the other accented characters would need to be added as well.

Allan

nestoronald

Hi, i downloaded the version 1.10 of datatable, insert the code in my project and still the problem.

allan

Can you please link to the page showing the problem. I've just tried it and it worked okay.

Allan

nestoronald

Here the link:
http://immense-journey-5655.herokuapp.com/
Help please.

allan

Put the DataTables initialisation _after_ you modify how the search works :-)

Allan

nestoronald

Thanks, it works

allan

Excellent! I'll look at creating a proper published plug-in for this at some point then which deals with all accented characters.

Allan