If String IsEmpty or Null Write Custom Value

[Shyam_Pragash]

Hi.

i tried to write custom value in the database…if string isempty or null…

String.IsNullorEmplty(CurrentRow(“Column Name”).ToString.Equals(“Null Data”).ToString…

Unable to Write Null Data (Custome text)

Thanks
Shyam

[Gokul001 (Gokul Balaji)]

Hi @Shyam_Pragash

@Shyam_Pragash

String.IsNullorEmplty(CurrentRow(“Column Name”).ToString.Equals(“Null Data”).ToString

Try like below expression

String.IsNullorEmplty(CurrentRow(“Column Name”).ToString.Equals(“”).ToString

Regards
Gokul

[ashwin.ashok ((TheCodingTheory))]

Hi @Shyam_Pragash ,

If you are trying to check whether a string is null or empty, then this ought to do the trick:

IsNothing(CurrentRow(ColumnNameOrIndex)) OrElse String.IsNullOrEmpty(CurrentRow(ColumnNameOrIndex).ToString)

Kind Regards,
Ashwin A.K

[Shyam_Pragash]

Hi.

Where i mension the custom text ?

[Gokul001 (Gokul Balaji)]

HI @Shyam_Pragash

Use if condition

If the column is empty or null

Then
Use Assign activity

LHS → Currentrow(“ColumnName”)
RHS → “Custom Text”

Write range activity to write the data in the excel

Regards
Gokul

[ashwin.ashok ((TheCodingTheory))]

Is this what you meant?

If(IsNothing(CurrentRow(ColumnNameOrIndex)) OrElse String.IsNullOrEmpty(CurrentRow(ColumnNameOrIndex).ToString),"CustomText", CurrentRow(ColumnNameOrIndex))

AssignCustomValuesIfNull.xaml (8.9 KB)

Kind Regards,
Ashwin A.K