Remove some Zeros but Not All

Question

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!

binu_acs · Answer

@mmh2023 Another option with the string functions

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

BS_THE_ANALYST · Answer

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

binu_acs · Answer

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