Ignore characters in data in order to have data sorted alphabetically

lionellionel

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

kthorngren

Use Orthogonal data to remove the leading characters using regex. For example:
https://jsfiddle.net/58podts6/

Kevin

lionellionel

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

lionellionel

It works but not in the fiddle, thank you for your wonderful help!