How to remove null values from a array. For example
var data = [
["George L. Bunting", null, null, null],
["Marc G. Bunting", null, null, null],
["Suzanne F. Cohen", null, null, null],
["Rosalee Davison", null, null, null],
["Richard Davison", null, null, null],
["Marilynn K. Duker", null, null, null],
["Dale McArdle", null, null, null],
[null, null, null, null],
[null, null, null, null],
[null, null, null, null]
]
I required to get like this
data = [
["George L. Bunting", null, null, null],
["Marc G. Bunting", null, null, null],
["Suzanne F. Cohen", null, null, null],
["Rosalee Davison", null, null, null],
["Richard Davison", null, null, null],
["Marilynn K. Duker", null, null, null],
["Dale McArdle", null, null, null]
]
and remove space between words 'Dale McArdle'-> 'Dale McArdle'?
$("input[id*=btnListGeneratorwithDetails]").click(function() {
$("[id*=hdnfldSpreadSheetData]").val(JSON.stringify(handsontable.getData()));
strEntityList = JSON.stringify(handsontable.getData());
//alert(strEntityList);
});