Hi everyone, can anyone please help me into this, I have one datatable in which i have to replace each “%%” sign with “,” . Please help me how can I. Achieve this . The datatable which I have is too large , number of Columns and large, I just want, in single shot it will replace all item as %% to…

can you check: [image] LINQ query to update(replace)datatable in uipath Help @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…

Where did the data in the datatable come from? Maybe there’s a way to do this replacement before loading into the DT. Also, anything loops. There is no such thing as “single shot.” Don’t mistake Linq for meaning “doesn’t loop.” You could just as easily do this with For Each Row and Assigns to d…

First I have one text file from that I replced comma with %% ,then I converted that into csv file by using (vbtab,‘,’) so now I wanted to replace all %% by , again in converted CSV file Please help

Thank you, it is working :grinning:

Why don’t you just do the extra step of converting %% to what you want the same way you did the other replacements? Or in the automation you just read it in as a text file into a string variable and do a Replace. Then re-write the text file.

Manipulation on Datatable -help

Help Studio

ppr (Peter Preuss) January 8, 2022, 10:06pm 2

can you check:

Replace("%%" , ",")

Topic		Replies	Views
Replace a string with another string from the entire data table Activities excel , activities , question	14	5056	October 22, 2021
How to replace a value in datatable in Uipath without using for each row Help datatable , excel , activities , question	5	21642	December 5, 2019
I need to replace Text in excel . There are 32 colums with header and 1000+ rows with values. If Value contains "Milestone" i need to replace with "Yes" Activities excel	11	1379	May 12, 2022
Replace all commas in Datatable with Fullstop? Studio question	6	1208	August 29, 2023
Replace one value with another in a specific column Community question , community	11	2912	September 27, 2022

Manipulation on Datatable -help

Related topics