I can't able to fiter empty column

Help Activities
, ,
1

I can’t able to filter the empty rows from the data table because column0 has some spaces in empty cells, how to trim that empty cells and remove the entire row if the column0 cell is empty.

2

Do a for each row of your datatable then reassign all cells to themselves with trim.
For example, inside for each row of datatable
Currentrow(0) = Currentrow(0).ToString.Trim

1 Like
3

Thank you :blush: issue is resolved

1 Like
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.