DataTables.js Sort columns containing HTML links with integer text

Question

I'm trying to sort columns in DataTables.js that contain HTML anchor tags. The text within the anchor tag is an integer, like `123`. I want to sort the columns numerically. In the documentation examples, there is DataTables HTML sorting auto-detection example. I tried this but it doesn't solve my issue - it does correctly parse the text out of the HTML, however, it treats the resulting text as a string and not an integer. Example output: ``` 0, 0, 1, 14, 67, 67, 7 ``` Desired output: ``` 0, 0, 1, 7, 14, 67, 67 ``` How can I parse the `` text as an integer prior to sorting? Code JSFiddle This is original JSFiddle without above update(s): http://jsfiddle.net/adamtsiopani/V4Ymr/ JavaScript ``` $(document).on('ready', function() { $('.data-table').dataTable({ "bPaginate": true, "bFilter": true, "bSort": true, "bAutoWidth": false, "iDisplayLength": 100, "sPaginationType": "full_numbers", "sDom": '<"tools"T><"top"flip>rt<"bottom"lfip><"clear">', "oTableTools": { "aButtons…

Accepted Answer

Here's a solution: http://jsfiddle.net/adamtsiopani/V4Ymr/8/ ``` jQuery.fn.dataTableExt.oSort['numeric-html-asc'] = function(a,b) { a = parseInt($(a).text()); b = parseInt($(b).text()); return ((a < b) ? -1 : ((a > b) ? 1 : 0)); }; jQuery.fn.dataTableExt.oSort['numeric-html-desc'] = function(a,b) { a = parseInt($(a).text()); b = parseInt($(b).text()); return ((a < b) ? 1 : ((a > b) ? -1 : 0)); }; $('.data-table').dataTable({ //set the sType to the custom type provided above "aoColumns": [ null, { "sType": "numeric-html" }, { "sType": "numeric-html" }, { "sType": "numeric-html" }, { "sType": "numeric-html" }, { "sType": "numeric-html" }, { "sType": "numeric-html" }, { "sType": "numeric-html" } ] }); ``` Answer Based On - Documentation: Sorting without automatic type detection - StackOverflow: This Answer

DataTables.js Sort columns containing HTML links with integer text

Solution

Problem

Related problems