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
@Juan_Esteban_Valencia - Here you go…
(?<=.+,)\d{2}
Please mark it as solution, if it solves your query.
1 Like
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}
1 Like
@Juan_Esteban_Valencia - Did you tried the code provided? If working, please mark it as solution that will close this thread.
@Steven_McKeering @prasath17 Thank you very much, it served perfectly
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.