Convert string to decimal with format

Question

I need convert a String to a decimal in C#, but this string have different formats.

For example:

"50085"

"500,85"

"500.85"

This should be convert for 500,85 in decimal. Is there is a simplified form to do this convertion using format?

Decimal doesn't store in the format of "500,85". Are you asking for a pair of Decimals? — myermian
– myermian, Commented May 11, 2011 at 11:19
@myermian: Well, it could, depending on your culture/locale settings. Not everyone represents decimal values the same way. In this example, 500,85 might be equivalent to 500.85. — Cody Gray
– Cody Gray ♦, Commented May 11, 2011 at 11:36

Peter Mortensen · Accepted Answer · 2017-02-19 21:19:42Z

25

Some cultures use a comma to indicate the floating point. You can test this with the following code on an aspx page:

var x = decimal.Parse("500,85");
Response.Write(x + (decimal)0.15);

This gives the answer 501 when the thread culture has been set to a culture that uses the comma as floating point. You can force this like so:

var x = decimal.Parse("500,85", new NumberFormatInfo() { NumberDecimalSeparator = "," });

edited Feb 19, 2017 at 21:19

Peter Mortensen

31.4k22 gold badges110 silver badges134 bronze badges

answered May 11, 2011 at 11:31

James McCormack

10.1k4 gold badges56 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Chris Shaffer · Accepted Answer · 2011-05-11 11:30:47Z

While decimal.Parse() is the method you are looking for, you will have to provide a bit more information to it. It will not automatically pick between the 3 formats you give, you will have to tell it which format you are expecting (in the form of an IFormatProvider). Note that even with an IFormatProvider, I don't think "50085" will be properly pulled in.

The only consistent thing I see is that it appears from your examples that you always expect two decimal places of precision. If that is the case, you could strip out all periods and commas and then divide by 100.

Maybe something like:

public decimal? CustomParse(string incomingValue)
{
    decimal val;
    if (!decimal.TryParse(incomingValue.Replace(",", "").Replace(".", ""), NumberStyles.Number, CultureInfo.InvariantCulture, out val))
        return null;
    return val / 100;
}

I dont find any format to resolve my problem. I use this implementation and add decimal places. Thanks

Jaymz · Accepted Answer · 2011-05-11 11:25:56Z

6

This will work, depending on your culture settings:

string s = "500.85";
decimal d = decimal.Parse(s);

If your culture does not by default allow , instead of . as a decimal point, you will probably need to:

s = s.Replace(',','.');

But will need to check for multiple .'s... this seems to boil down to more of an issue of input sanitization. If you are able to validate and sanitize the input to all conform to a set of rules, the conversion to decimal will be a lot easier.

edited May 11, 2011 at 11:25

answered May 11, 2011 at 11:17

Jaymz

6,3982 gold badges29 silver badges30 bronze badges

3 Comments

Chris Shaffer Over a year ago

+1 for mentioning input sanitization... -1 for not handling "50085". Balances out to no vote :)

V4Vendetta Over a year ago

I fear there could also be a input like 50.865,85

Jaymz Over a year ago

@Chris, 50085 would result in 50085 after decimal.Parse... I'd accept the no vote though, as I don't think this fully answers the OPs question. :)

Peter Mortensen · Accepted Answer · 2017-02-19 21:24:19Z

Try this code below:

string numValue = "500,85";
System.Globalization.CultureInfo culInfo = new System.Globalization.CultureInfo("fr-FR");
decimal decValue;
bool decValid = decimal.TryParse(numValue, System.Globalization.NumberStyles.Number, culInfo.NumberFormat, out decValue);
if (decValid)
{
    lblDecNum.Text = Convert.ToString(decValue, culInfo.NumberFormat);
}

Since I am giving a value of 500,85 I will assume that the culture is French and hence the decimal separator is ",". Then decimal.TryParse(numValue, System.Globalization.NumberStyles.Number, culInfo.NumberFormat,out decValue); will return the value as 500.85 in decValue. Similarly if the user is English US then change the culInfo constructor.

Peter Mortensen · Accepted Answer · 2017-02-19 21:26:05Z

3

This is a new feature called Digit Grouping Symbol.

Steps:

Open Region and Language in control panel
Click on Additional setting
On Numbers tab
Set Digit Grouping Symbol as custom setting. Change comma; replace with (any character as A to Z or {/,}). Digit Grouping Symbol=e;

Example:

string checkFormate = "123e123";
decimal outPut = 0.0M;
decimal.TryParse(checkFormate, out outPut);
Ans: outPut=123123;

edited Feb 19, 2017 at 21:26

Peter Mortensen

31.4k22 gold badges110 silver badges134 bronze badges

answered Oct 19, 2012 at 4:24

Mohd Vasil

311 bronze badge

Comments

Peter Mortensen · Accepted Answer · 2017-02-19 21:18:36Z

2

There are numerous ways:

System.Convert.ToDecimal("232.23")
Double.Parse("232.23")
double test; Double.TryParse("232.23", out test)

Make sure you try and catch...

edited Feb 19, 2017 at 21:18

Peter Mortensen

31.4k22 gold badges110 silver badges134 bronze badges

answered May 11, 2011 at 11:23

Amarnauth Persaud

5376 silver badges19 bronze badges

Comments

halo89 · Accepted Answer · 2018-11-06 11:35:08Z

1

Try This

 public decimal AutoParse(string value)
    {
        if (Convert.ToDecimal("3.3") == ((decimal)3.3))
        {
            return Convert.ToDecimal(value.Replace(",", "."));
        }
        else
        {
            return Convert.ToDecimal(value.Replace(".", ","));
        }

    }

answered Nov 6, 2018 at 11:35

halo89

1011 silver badge1 bronze badge

Collectives™ on Stack Overflow

Convert string to decimal with format

7 Answers 7

Comments

1 Comment

3 Comments

Comments

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

Comments

1 Comment

3 Comments

Comments

Comments

Comments

Comments

Linked

Related