Sort Issue with Special Character in Multiple column

Uzairkhan92

Link to test case:
https://jsfiddle.net/Uzair92/g7shyw2f/1/
Debugger code (debug.datatables.net):
Error messages shown:
Description of problem:
Above is the URL of my Actual Grid.
In the grid, there are strings and special characters.

I am unable to sort 2, 3 (Net Worth, Cash) Column in the grid, there are some negative values as well in the grid,
so Kindly fix the issue in the JSfiddle.

kthorngren

Maybe you posted the wrong link or didn't save the jsfiddle but there is nothing in your test case.

Kevin

Uzairkhan92

I have updated the link.
https://jsfiddle.net/Uzair92/g7shyw2f/1/
Plz check

kthorngren

Did you try the technique I showed in your previous thread? You just need to adjust the regex expression to math the format of your data. Something like this:
https://jsfiddle.net/50b8nvdp/

Kevin

Uzairkhan92

Yeah, right it's working but how can use two regex expressions at the same time,
Because for 4th and 5th column regex will be different, for 2nd and 3rd (Net worth, Cash) column regex will be different.

kthorngren

columnDefs is an array. All you need to place both configurations in the array, like this:
https://jsfiddle.net/2jy3xLke/

Kevin

Uzairkhan92

Thanks Its working