Check if there is a value in cell

Help Studio
1

Data

Hi everyone, working on an excel sheet I would like too:

Example row2:

  • Check if there is a value in the credit or debit column
  • Send validation to confirm If debit value is empty
  • If there is a value save the data as it is. If the value is from Debit, save the number only

What’s the best way to achieve this

2

for checking if a column is empty we do use following statement:

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

We can use it e.g.

  • for each row - looping over the datatable after read in the excel with a read range
    • within an if activity
3

thank you, i received an - “)” expected error

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

  • isNothing(row("Credit) OrElse String.IsNullOrEmpty(row(“Debit”).toString.Trim), not too sure where to look

Thank you I have used it inside the for loop, within the IF activity

4

check for this:
isNothing(row(ColNameOrIndex)) - closing )

1 Like