Hello everyone, I am using a read range activity an excel file that I get from someone at work. My automation will upload that file to another program. That excel table contains many columns with numbers and if the numbers contain commas(,) then the upload will fail. Normally I would use “For Eac…

@dvn - Please check this post… [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…

Hi @dvn You can try this way too Use this code to use in invoke code activitiy with dt1 as in/out argument dt1.AsEnumerable().ToList().ForEach(Sub(row) row.ItemArray.ToList().ForEach(Sub(e) e.ToString.Trim.Replace(“,”,“”))) let me know if it works for you Regards Nived N :robot: Happy Automat…

Remove all commas from datatable

Help Activities

prasath17 (Guru) April 12, 2021, 1:32am 2

@dvn - Please check this post…

Topic		Replies	Views
Remove commas from a datatable Studio	3	287	January 31, 2024
Replace all commas in Datatable with Fullstop? Studio question	6	1213	August 29, 2023
Removing character from column Help datatable , excel , studio	19	4271	December 12, 2019
Remove comas from data table or txt Activities uiautomation , activities , question	40	1421	August 30, 2023
Replace dot with comma Robot datatable , excel , robot , activities , question	10	2392	April 27, 2022

Remove all commas from datatable

Related topics