Check if DataRow has empty fields and/or change empty field values to 'n/a' in one expression

[Paul_Dom]

Hi, can someone help to solve a problem:

I need to check if DataRow has empty fields(if so - which ones) and/or change empty field values to ‘n/a’ in one expression.

Worst case this logic can be aplied to whole datatable. Please do not suggest other activities then Assign.

[lakshman (Ganta lakshman)]

@Paul_Dom

Welcome to our UiPath community.

Have a look below thread.

LINQ query to update(replace)datatable in uipath

@Rachel7 this is maybe a too quick shot as it replace any space in any column to NA and returns a datatable. But you can give a try (From r In dtData.AsEnumerable Select ia = r.ItemArray.toList Select ic = ia.ConvertAll(Function (e) e.ToString.Trim.Replace(" ","NA")).toArray() Select dtCorrected.Rows.Add(ic)).CopyToDataTable() NEW VERSION, simplified: (From r In dtData.AsEnumerable let ra = r.ItemArray.Select(Function (x) x.ToString.Trim.Replace(" ","NA")).toArray() Select dtCorrected.Rows.…