Regex for removing trailing zeros

Question

I am looking for a regular expression (.NET) to remove trailing zeros:

11645766.560000001000   ->  11645766.560000001
10190045.740000000000   ->  10190045.74
1455720.820000000100    ->  1455720.8200000001  

etc...

---

I am using regex, over String.Trim(), because the numbers are in one string, actual example:

!BEGIN !>>C85.18 POS_LEVEL.T129{11645766.560000001000} = POS_LEVEL.T129 {10190045.740000000000} + WORK_LEVEL.T129{1455720.820000000100} END;

need to convert to:

!BEGIN !>>C85.18 POS_LEVEL.T129{11645766.560000001} = POS_LEVEL.T129{10190045.74} + WORK_LEVEL.T129{1455720.8200000001} END;

Answer 1

In .Net you can do the following

var newStr = Regex.Replace(input, "0+$",String.Empty);

Answer 2

([0]+)\b

then delete $1

Answer 3

If the numbers are embedded in a random string, regexes are the way to go:

Replace (?<=\.\d+?)0+(?=\D|$) with an empty string

That will trim trailing zeros if they appear after the period in a decimal number (it will always leave a single zero). It also accounts for numbers that appear at the very end.

And since you've added the .NET tag in the meantime, here's the code:

string replaced = Regex.Replace(
                         inputString,
                         @"(?<=\.\d+?)0+(?=\D|$)",
                         String.Empty);

Answer 4

One caveat on the above RegEx AND Trim()... if your input does NOT have a decimal point, you could end up with wrong numbers. E.g., ("1000").TrimEnd('0') = 1.

This workaround will fix that issue:

string Trimmed = (Untrimmed.IndexOf('.')>=0) ? Untrimmed.TrimEnd('0') : Untrimmed;

Of course, the use of a "." for decimals is culture-specific--some cultures use commas. If you're trying to built in culture-awareness, you need to use System.Threading.Thread.CurrentThread.CurrentCulture.NumberDecimalSeparator instead of a literal '.' character.

Edit: Based on your edited question above, RegEx is the right answer. Something like:

Trimmed = RegEx.Replace(Untrimmed, "(\d\.\d*[1-9])0+([^\d]|$)", "$1$2");

(The [1-9] above is my lazy way to avoid \d being greedy and capturing the 0's, there's likely a more straightforward way to do it.)

Answer 5

The following will match zeros that follow a decimal point and any number of decimals, and that do not precede a decimal point or digit.

(?<=\.\d*)(0+)(?=[^.\d])