How To Check If Columns in a datatable is NOT Blank

redbee · January 18, 2020, 12:50am

Hi All,

how to check if column B onwards in the datatable is NOT blank using If ACTIVITY in a For each row.

I have 6 different columns that I want to check.

Can any on help on this ASAP?

AndersJensen · January 18, 2020, 1:19am

dtIF

redbee · January 18, 2020, 1:34am

What if only columns B,C,D,E are the ones I want to check?

AndersJensen · January 18, 2020, 1:43am

You can make an or:

row.Item(“B”).ToString <> “” or row.Item(“C”).ToString <> “” or row.Item(“D”).ToString <> “” or row.Item(“E”).ToString <> “”

Thats it. True for rows with no blank cells. However if you wanna check them seperately you can make 4 'If’s.

Yoichi · January 18, 2020, 2:14am

Hi,

Do you mean to check all the data of the column is not blank?
If so, the following sample might help you.

Regards,

redbee · January 18, 2020, 2:31am

It worked. Thanks a lot

system · January 21, 2020, 2:32am

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

Topic		Replies	Views
How to check a specific column in the datatable is blank or not Help	13	16538	October 24, 2019
Check if a datatable contains rows with Null or Blanks in any Column/Cells Activities datatable , excel , activities , question	2	4034	May 10, 2021
How to check if a particular column is empty in DataTable (Without using For Each Row)? Help datatable , excel , studio	15	20568	September 30, 2021
How to check if the columns of datatable contains string Academy Feedback	2	1522	July 5, 2020
How to check if a datatable (excel) contains empty cells Help excel	13	7722	October 29, 2018