How to find if the value in particular column is empty or not

Help Activities
, , , , , , , , ,
1

S.no. Value

  1.             2

  2.             40

  3.             59

  5.              60

Here you can see the line number 4 value column has no value it is empty

I need to check it is empty or not and my output should in Boolean ie true or false

Note: should not used for loop

2

Hi @sruthesanju

Try this

YourDataTable.AsEnumerable().Any(Function(row) String.IsNullOrWhiteSpace(row("Value").ToString()))

image
image878×362 12.4 KB

Regards,

3

Hi @sruthesanju

Try this:

Assign: isEmpty = If(yourDataTable.AsEnumerable().Any(Function(row) String.IsNullOrWhiteSpace(row("Value").ToString())), True, False)

image
image975×655 20 KB

Hope it helps!!

4

@sruthesanju

String.IsNullOrEmpty(yourDataTable.Rows(3)("column_name").ToString)
5

Hi @sruthesanju ,

Could check with what @Parvathy as provided but maybe not needed to re-validate again :

yourDataTable.AsEnumerable().Any(Function(row) String.IsNullOrWhiteSpace(row("Value").ToString))
6

Hi @sruthesanju

Use the below linq expression,

- Assign -> Bool_Flag = dt.AsEenuemarable.any(Function(X) String.isNullorEmpty(X("Value").toString))

The above expression will work, if any row in the Value column is empty then it will throw the True as output else false.

Note - Bool_Flag is the Boolean datatype variable.

Hope it helps!!

7

@sruthesanju

dt.AsEnumerable.any(Function(a) string.IsNullOrEmpty(a("Value").ToString.Trim))

or you can use

dt.AsEnumerable.any(Function(a) string.IsNullOrEmpty(a(0).ToString.Trim))
8

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