i have lots of values in my data table that contain commas e.g. “2,7” but i want to replace that comma with a full stop E.G “2.7”. how can i archive this for all values in datatable?

Hi @Rowley101 You can use this condition in Assign activity inside For Each Row in Data Table CurrentRow("Column Name")=CurrentRow("Column Name").ToString.Replace(",",".") Hope it helps!!

Does that mean i have to do that for every column?

@Rowley101 It will do for every row of a particular Column. Regards,

[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 Select ic = ia…

Hi @Rowley101 => Use the read range workbook activity to read the rows in the excel and store in a datatable. => Use for each row in datatable activity to iterate the rows in the datatable. => Inside for each insert the Assign activity and give the below expression - Assign -> row("ColumnName") …

Hi @Rowley101 , You can try to use the following convert to string the dataTable with Output Data Table Activity and then remplace all “,” in string [image] and after you can generate again the data table from that string with Generate Data Table Activity [image] in option use the next [image] …

Replace all commas in Datatable with Fullstop?

Help Studio

ppr (Peter Preuss) August 29, 2023, 2:55pm 5

where we just adapt:

Replace(",",".")

Topic		Replies	Views
Remove all commas from datatable Activities activities , question , document-processing	2	3175	April 12, 2021
Replace dot with comma Robot datatable , excel , robot , activities , question	10	2388	April 27, 2022
Replace commas with dots Studio studio , question , activities-panel	4	122	July 29, 2024
Replace comma with dot Robot robot , question	7	1355	May 1, 2023
Remove commas from a datatable Studio	3	284	January 31, 2024

Replace all commas in Datatable with Fullstop?

Related topics