Is this the proper REGEX to remove trailing decimal and zeroes from a string? I can't get it to work. What am I missing?
str.replaceAll("^.0*$", "");
You can remove trailing zeros using TRIM() function.
Select the adjacent cell to the number you used. Type this formula =LEFT(D1, LEN(D4)-2)*1, D4 is the cell you will remove trailing zeros from, 2 is the number of zeros you want to remove.
You need to escape the .
, as it is a special character in Regex that matches any character. You also have to remove the ^
, which anchors at the beginning of the number.
str.replaceAll("\\.0*$", "");
You can use a lookbehind if you want to make sure there is a number in front of the dot, like this:
str.replaceAll("(?<=^\\d+)\\.0*$", "");
The lookbehind (the (?<=...)
part) is not a part of the match, so it will not be replaced, but it still has to match for the rest of the regex to match.
Nope. Use this:
str.replaceAll("[.0]+$", "");
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With