How can i remove columns which contains 0 using Jquery
I have a table which contains suppose 4 columns i want to remove columns which contains 0 from first row to las开发者_运维技巧t row. In this case i want to remove 2nd & 4th column how can i achieve this using jquery
1 0 10 0
2 0 20 0
3 0 30 0
o/p should be
1 10
2 20
3 30
To clear all columns which consist of only zeros, you could first identify the 0 containing cells in first row, and for those cells, check how many 0 containing cells are in that column. If it matches total rows, then remove them.
var rows = $('tr').length;
$('tr:first td:contains(0)').each(function(){
var i = $(this).index()+1;
var s = $('tr td:nth-child('+i+')');
if(s.filter(':contains(0)').length==rows) s.remove();
});
example: http://jsfiddle.net/niklasvh/frdsc/
You will need to iterate through all the cells to check for zeros in each column, this may help: How to loop through table cells with jQuery and send the data to database
$("table td")
.filter(function () {
// cellIndex will be 0 for the first column, 1 for the second, and so on
return (this.cellIndex == 1 || this.cellIndex == 3);
})
.remove();
精彩评论