Remove numbers from a string

Build
,
#1

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

#2

@Juan_Esteban_Valencia - Here you go…

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

image

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

1 Like
#3

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}

1 Like
#4

@Juan_Esteban_Valencia - Did you tried the code provided? If working, please mark it as solution that will close this thread.

#5

@Steven_McKeering @prasath17 Thank you very much, it served perfectly

#6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.