Linq Query to Replace empty value from a column with a constant value

[JITU99 (jitendra)]

Hi

Can you help me with Linq Query.

if column2 from my datatable has null or empty value then i need to fill it with 100.

[lrtetala (Lakshman Reddy)]

Hi @JITU99

Please check below thread

Replace blank column value with specific value using linq

we would suggest to do it with a for each row activity loop. For learning purpose a LINQ could look like this For Each row As Datarow In dt.AsEnumerable().Where(Function (r) IsNothing(r("Column1")) OrElse String.IsNullOrEmpty(r("Column1").toString.Trim)) row("Column1") = "Undefined" Next used within Invoke Code Here we only do use LINQ for the filtering and do mirroring the for each activity on code. Updating is stressing the LINQ concept and results quickly to avoidable black box approac…

Regards,

[lrtetala (Lakshman Reddy)]

@JITU99

Another approach

By using excel activities

Use Find/Replace Value activity

Where to search: Excel.Sheet(“Sheet1”). Range(“B:B”)

Value to find: String.Empty

Replace with: “100”

Regards,