How to filter out/remove cells that contains empty

Help Automation Suite
, ,
1

Hello everyone,

I was wondering how can I filter out and remove the cells that contains empty in an excel file?

From
image

To
image

I have tried to use the filter wizard, but it would not filter and remove the cells out
image

2

Contains(“”) makes no sense.

You want to use IsEmpty for the Operation

1 Like
3

check for the operation isEmpty and use an or instead of AND

2 Likes
4

Thank you!

5

Thank you! it works now

6

or Else ;

DT.Asenumerable.Where(Function(r) Not (String.isNullorEmpty(r(“Start Date”).Tostring.Trim) or String.isNullorEmpty(r(“End Date”).Tostring.Trim))).Copytodatatable

7

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