Answers

• HPB Posts: 73Questions: 2Answers: 18

  October 2017 Answer ✓

  columns.render is exactly what you need for this.
  The function will also give the type, and you can use that to only add miles for display purposes.

  render: function ( data, type, row, meta ) {
     if(type === 'display')
        return data + ' miles';
     return data;
  }
  
• allan Posts: 63,214Questions: 1Answers: 10,415 Site admin

  October 2017

  Yup - orthogonal data is great for this sort of thing.

  The other option is to use a sorting plug-in like this one which will strip everything but numeric data.

  Allan
• MDR Posts: 2Questions: 1Answers: 0

  October 2017

  Thanks that worked. Here is the final code for anyone looking. In this case the column in question is the 6th one.

  $('#datatable').dataTable({
                                  aoColumns: [
                                      null,
                                      null,
                                      null,
                                      null,
                                      null,
                                      null,
                                      { "bSortable": false }
                                  ],
                                  "columnDefs": [ {
                                      "targets": 5,
                                      "data": "distance",
                                      "render": function ( data, type, row, meta ) {
                                        if(type === 'display'){
                                            return data + ' miles';
                                            }
                                         return data;
                                      }
                                    } ]
                              });