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!
@mmh2023 What is the data type of your Account field? is it double?
perhaps LEFT([RegExOut1],4) is also achieving what you want? If you only want the first 4 digits @mmh2023
@mmh2023 Another option with the string functions
ReverseString(Substring(ReverseString(toString([ RegExOut1])),2,Length(toString([ RegExOut1]))))