How do I replace undefined column value to blank string?

BrettA

Hi, I am running Datatables on a SharePoint 2013 doc library and if a field is empty for a specific item, Datatables displays the value as "undefined".
Can someone please tell me how to replace "undefined" with a "tba" string or blank value or whatever?
I have looked everywhere but cannot find the answer.
Thanks.

colin

Hi @BrettA ,

The way to go is with columns.render, see the examples near the bottom of the page. You can just test for "undefined", and return any other string, such as "tba".

Cheers,

Colin

BrettA

Hi Colin, thanks for replying but I cannot see what you are referring to.
Can you paste the code here, so I can try it please?
Thanks.

bindrid

in cols or columnDefs do something like

columnDefs:[{targets:[3], render:function(data){if(data == null) {return "tbd"} else {return data}}

BrettA

Thank you bindrid,
I changed your code a little, used "undefined" and it works now:

{"render":function(data){if(data == "undefined") {return "tbd"} else {return data}}, "targets": [1,2,3,4] },

bindrid

with 2 == signs, the if statement checks for both a null and a undefinded in javascript