Sort string data as Int in jquery DataTable

I would use a columnDef object to specify a render function like so:

$('#tblProviders').dataTable({
 "autoWidth": false,
 "searching": false,
 "pageLength": 6,
 "lengthMenu": [6, 10, 25, 50, 75, 100],
 "bDestroy": true,
 data: obj.data.ProviderQualificationDetails,
 columns: [
   { "data": "ProviderName" },
   { "data": "ProviderQualificationTime" },
   { "data": "TotalServiceableOffers" }
 ],
 "columnDefs": [ {
    "targets": 1,
    "render": function ( data, type, full, meta ) {
       // If this is a display render request ...
       if(type === 'display') {
         // don't modify it.
         return data;
       }

       // Either convert it to a number if it is a numeric value or set it to 0
       // This will return a numeric value for sorting and filtering.
       return (isNaN(data)) ? 0 : +data;
    }
 }]
});

So with the custom renderer for your column you can have a unmodified display value and a converted sort/filter value.

With HTML5 data attributes you can specify data-order. This will allow the datatable to order the content differently from the data that is actually displayed:
https://datatables.net/examples/advanced_init/html5-data-attributes.html

For example:

<td data-order='0'>NotAccepted</td>

This is ugly but works:

$(document).ready(function() {
  jQuery.extend(jQuery.fn.dataTableExt.oSort, {
    "numNonStandard-asc": function (a, b) {
      var x = isNaN(parseInt(a, 10)) ? 0 : parseInt(a, 10);
      var y = isNaN(parseInt(b, 10)) ? 0 : parseInt(b, 10);
      return (x == y) ? 0 : (x < y) ? 1 : -1;
    },
    "numNonStandard-desc": function (a, b) {
      var x = isNaN(parseInt(a, 10)) ? 0 : parseInt(a, 10);
      var y = isNaN(parseInt(b, 10)) ? 0 : parseInt(b, 10);
      return (x == y) ? 0 : (x < y) ? -1 : 1;
    }
  });
  $('.table-data').DataTable({
    columnDefs: [
      { type: 'numNonStandard', targets: -1 }
    ]
  });
});

Working example.

Just add the given below parameter:

"sType": "string"

For more details visit the link [https://datatables.net/forums/discussion/24284/column-sort-wrong-data-always-string]

Please refer https://datatables.net/plug-ins/sorting/signed-num

and in first IF condition that is return (a=="-" || a==="") ? 0 : a.replace('+','')*1; add one more or condition like (a == "-" || a === "" || a == "NotAccpeted") ? 0 : a.replace('+', '') * 1;