hi, i have code to find and replace “mohan/any” string value into “Retrieved and added to Queue” in the column-> Status. as you can see below. dt.Select(“Status=‘mohan’” ).ToList().ForEach(Sub(row) row(“Status”)=“Retrieved and added to Queue”) But i need to replace with empty row with this value…

[image] Sudharsan_Ka: dt.AsEnumerable.Where(Function(row) String.IsNullOrEmpty(row(“Status”).ToString)).ToList().ForEach(Sub(row) row(“Status”) = “Retrieved and added to Queue”) Check the above one or the below one dt.AsEnumerable.Where(Function(row) String.IsNullOrWhiteSpace(row("Status").T…

Hello @manipreethi410 Please check whether the below post can help you. [image] LINQ query to update(replace)datatable in uipath Help dt.Select(“[Col2] like ‘% %’”) This will give you list of data rows then use for each then check if condition row[Col2]=“” then take a…

This contains many activities the code should have in single line, which like I have mentioned above. Where ever I used Mohan, I just have to replace with null value here am facing the issues, Am not getting how to pass null or empty row here in the code. Please help me with that.

Hi @manipreethi410 Can you share the sample input and Output excel file Regards Gokul

Hi @manipreethi410 Try this code for replacing the empty to a given string in the invoke code activity dt.AsEnumerable.Where(Function(row) String.IsNullOrEmpty(row("Status").ToString)).ToList().ForEach(Sub(row) row("Status") = “Retrieved and added to Queue”) [image] You need to pass the same d…

[image] Sudharsan_Ka: You need to pass the same dt in the arguments And you need to change the direction to out @manipreethi410

@manipreethi410 If your query resolved kindly mark your solution and close the topic so that it will be helpfull for others Regards Sudharsan

Replace empty row with string values

Learning Hub Certification

Rahul_Unnikrishnan (Rahul Unnikrishnan) September 22, 2022, 11:17am 2

Hello @manipreethi410

Please check whether the below post can help you.

Thanks

Topic		Replies	Views
LINQ query to update(replace)datatable in uipath Help datatable , excel , activities , question	7	18907	December 5, 2019
Replace empty cell with 0 using LINQ Help excel , activities , question	22	5824	November 19, 2020
Linq Query to Replace empty value from a column with a constant value Studio studio , question , activities-panel	2	139	September 19, 2024
Excel column filled with text replaced by empty spaces using linq Activities excel , question	7	621	August 17, 2023
How to replace a null value with empty string in datatable Varaiable Studio studio , question , activities-panel	3	1991	February 18, 2023

Replace empty row with string values

Related topics