How to Check For Null or Empty value in a Particular Column

Help Activities
, ,
2

@mohamedalthaf
Welcome to the forum

isNothing(row(ColNameOrIndex)) OrElse String.IsNullOrEmpty(row(ColNameOrIndex).toString.Trim)

can be used e.g. within an if activity for checking if col value is null or blank

in case of we want to check if in the data table 1 or more rows are present with a blank in a particular column we do:

dtBlankDemo.AsEnumerable.Any(Function (x) isNothing(x(ColNameOrIndex)) OrElse String.IsNullOrEmpty(x(ColNameOrIndex).toString.Trim))
1 Like