Remove some Zeros but Not All

[mmh2023]

Hi! 

I am trying to figure out a formula to remove the last three zeros in a string but still keeping one of the zeros so that it is a 4 digit number. 

For example: in the RegExOut1 column first line I would like for that to output to the account column as 1130 instead of 1130000

Thank you! 

[BS_THE_ANALYST]

@mmh2023 
REGEX_REPLACE([RegExOut1], "(.*)000$","$1")

[binu_acs]

@mmh2023 What is the data type of your Account field? is it double?

[BS_THE_ANALYST]

perhaps LEFT([RegExOut1],4) is also achieving what you want? If you only want the first 4 digits @mmh2023 

[binu_acs]

@mmh2023 Another option with the string functions

ReverseString(Substring(ReverseString(toString([ RegExOut1])),2,Length(toString([ RegExOut1]))))