Hello everyone, I have the following number in string format 648232,00500 I need it to only contain two numbers after the comma, how can I do this? This operation would have to be done for several numbers of a data table

Hi @Juan_Esteban_Valencia Further to @prasath17 ’s post… If your datatable only has numbers it will be fine however if it has rows which have words and numbers it will cause a problem I would suggest modifying @prasath17 ’s pattern like this: (?<=\d+,)\d{2}

Remove numbers from a string

Help

prasath17 (Guru) November 13, 2020, 9:08pm 2

@Juan_Esteban_Valencia - Here you go…

(?<=.+,)\d{2}

Please mark it as solution, if it solves your query.

1 Like

Topic		Replies	Views
Remove digits from string Activities datatable , excel , activities , string , question	16	1809	August 18, 2021
Remove decimal and Coma from Number/String Activities datatable , excel , uiautomation , studio , string , question , help	2	706	February 8, 2023
Removing the first numbers in a string Help	24	27501	January 11, 2019
Regex for remove newline Help activities , question	9	810	December 16, 2020
Substring: How to remove last two element from a string? Activities excel , activities , question	26	1979	May 11, 2021

Remove numbers from a string

Related topics