Remove decimal and Coma from Number/String

Tate_S · February 8, 2023, 5:25pm

Task 1
Input 2,000,000.00
Output 2000000

Task2
Input 45.0000
Output 45

Anil_G · February 8, 2023, 5:27pm

Please try this

Cint(str.Replace(",",""))

cheers

ppr · February 8, 2023, 5:28pm

we can ensure correct number handling e.g by Double parsing:
grafik

Topic		Replies	Views
How to replace . and , in a string that is number eg:-49.768,0000 should be equal to 49,768.00 Studio studio , question , activities_panel	4	246	November 2, 2023
Remove decimal seperators Academy Feedback excel , selector , uiautomation , pdf , studio , string , question	15	1617	August 17, 2020
How to get the string without the "," Help activities	4	731	January 23, 2021
Uipath remove comma and dot after decimal Studio selector , uiautomation , activities , data_scraping , string , question	3	1747	April 18, 2021
Remove numbers from a string Help studio , question	5	1029	November 20, 2020