How to replace null with some value ? i have tried with multiple logics, can anyone help me please?

[Veera_Raj (Veeraraj Sethuraman)]

{“xxxxxxxx”,
“Y”,
“Y”,
“”,
“Y”,
“”,
“”,
“Y”,
“”,
“”,
“Y”,
“”,
“Y”,
“Y”
}

[sb001]

Can you please elaborate on this

[Lokesh.Bysani]

Hi @Veera_Raj

I think this link should help you.

Removing all Empty or null Strings from a String Array, no looping

Any help?

[Yogesh1 (Yogesh)]

use try catch,

in exception handler, if the value is null, use assign activity to replace null with anything.

[Veera_Raj (Veeraraj Sethuraman)]

arr.Where(Function(x) Not String.IsNullOrWhiteSpace(x)).ToArray

how i replace null with “N” in this logic ?. can you help me out please?

[Veera_Raj (Veeraraj Sethuraman)]

i want yo replace null value in array with “N”, not in exception

[Veera_Raj (Veeraraj Sethuraman)]

i have array like {“xxxxx”,“”,“y”,“”,“y”}.want to replace Null with “N”
expected output is {“xxxxx”,“n”,“y”,“n”,“y”}

[Gokul001 (Gokul Balaji)]

Hi @Veera_Raj

Try with this Expression

Dt.AsEnumerable().Select(Function(row) row(“Column Name”).ToString.Replace(“”,“N”)).ToArray

Regards
Gokul

[Veera_Raj (Veeraraj Sethuraman)]

this is array only i dont have column name

[Veera_Raj (Veeraraj Sethuraman)]

or else i need query for replace all cell in datatable

[Gokul001 (Gokul Balaji)]

Hi @Veera_Raj

Have a look on the query

Replace Nulls With Specified Values in SQL Server.

Regards
Gokul

[sb001]

You can replace it like this
Index is an output variable of For each loop activity

Hope this helps,

Regards,
Saloni

[Veera_Raj (Veeraraj Sethuraman)]

this is for only specified column , can we make into dynamic ? means all column and row

[Lokesh.Bysani]

Hi @Veera_Raj

For an array you can try as below

arr_usernames.Select(Function(x) x.Replace(" ", “N”)).ToArray()

[Veera_Raj (Veeraraj Sethuraman)]

how to pass the array index?

[Veera_Raj (Veeraraj Sethuraman)]

this logic not giving result

[sb001]

You can pass it in properties of for each loop activity as output index of for each loop.

Regards,
Saloni

[sb001]

Please mark it as solution if its works out for you.

Thanks,

Regards,
Saloni

[pravin_calvin (pravin kumar)]

Hi @Veera_Raj

Use the expression below!

Assign LHS =arrayVar

RHS= arrayList.Select(Function (e) If(isNothing(e) OrElse String.IsNullOrEmpty(e.toString), “yourReplace Value”, e)).toArray

Refer to the screenshots below!

Regards

[Veera_Raj (Veeraraj Sethuraman)]

It’s working thank you