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 Each Row” to check for commas and remove them but since there are many columns to check, I was wondering if there is a better solution to remove all the commas from the datatable.
Thank you.