Search

Use columns.render to perform calculations in a cell based on the values of other cells in the row. See also the manual on renderers. Allan

This is not the ideal solution, but you can provide a special value when the column is being sorted (see columns.render). Then you can split the "-" and format the number.

can combine initComplete with column().search(). For example: initComplete: function

the search term for column().search() is how to clear

use a column filter - column().search(), or perhaps a UI

Use columns.render to do this. There is more detailed documentation also available here. Allan

All of the selectors you can use are defined in the jQuery documentation. You can also use column indexes as documented here in column-selector. Allan

Happy to take a look at a test case showing the issue. My guess is that you might be Ajax loading the table? In which case use columns.render to tell DataTables about the orthogonal data. Allan

Thanks for posting back. Yes, Editor basically ignores the columns.render option, instead working with the underlying data, so you can use whatever renderer you want. Allan

mention about using the columns.render (https://datatables.net//forums/discussion/comment/74121/#Comment_74121) but again not