Ignore characters in data in order to have data sorted alphabetically
Ignore characters in data in order to have data sorted alphabetically

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
It works but not in the fiddle, thank you for your wonderful help!