Ignore characters in data in order to have data sorted alphabetically
Ignore characters in data in order to have data sorted alphabetically
![lionellionel](https://secure.gravatar.com/avatar/67c3c38129b906a06f4f361784de0ef1/?default=https%3A%2F%2Fvanillicon.com%2F67c3c38129b906a06f4f361784de0ef1_200.png&rating=g&size=120)
Hello everyone,
In my Datatable, I have special character like or at the beginning of my data. Is-it possible to keep them visible but ignored by the sorted process. I wanted to have data displayed alphabetically but also in the column filter menu.
You can find a jsfiddle which displayed my problem.
https://jsfiddle.net/margarette/Lx7ysrn3/3/
I try to put them in a div not displayed but the order is not modify.
Thank you for your help,
Lionel
This question has an accepted answers - jump to answer
Answers
Use Orthogonal data to remove the leading characters using regex. For example:
https://jsfiddle.net/58podts6/
Kevin
wow
Thank you very much for your quick answer ! It works perfectly for the data.
However, it doesn't work for the column filter, when you click on the select, the order is still the wrong one![:/ :/](https://datatables.net/forums/resources/emoji/confused.png)
It works but not in the fiddle, thank you for your wonderful help!