How to convert "12,4" to decimal en-Us culture

Question

I have a decimal value ("133,3") stored in string column in the database, in norway culture.

after that user changed the regional setting to english-Us. when I convert "133,3" to decimal using CultureInfo.InvariantCulture, getting invalid value or error.

is there any best way to handle this scenario in C# application?

regards, Anand

Can you be explicit? is that meant to be 133 decimal-point 3, or 1333...? — Marc Gravell, Dec 01 '11 at 13:04
check this one as well: http://stackoverflow.com/questions/831727/c-sharp-decimal-parse-issue-with-commas — Davide Piras, Dec 01 '11 at 13:06
"133,3" in Norwagian culture comma is used as decimal separator. — Anand Kumar, Dec 01 '11 at 13:20

score 21 · Answer 1 · answered Dec 01 '11 at 13:03

21

Regardless of the system culture, if you specify CultureInfo.InvariantCulture you won't be able to parse "133,3" as a decimal to 133.3. The same is true for US English.

You could just specify a Norwegian culture when parsing the value (using the overload of decimal.TryParse which takes an IFormatProvider), or (preferrably) change the field in the database to reflect the real data type (a decimal number) instead.

answered Dec 01 '11 at 13:03

Jon Skeet

1,421,763
867
9,128
9,194

3

+1 - Yes. Only ever use culture specific code when passing data to/from the user e.g. by screen , email, print etc. A standard decimal in the database would be far better as this would allow code to more easily cope with changes in culture. – ChrisBD Dec 01 '11 at 13:11

score 11 · Answer 2 · answered Dec 01 '11 at 13:06

Do you referred to Convert.ToDecimal(), it says like

using System;
using System.Globalization;

public class Example
{
   public static void Main()
   {
      string[] values = { "123456789", "12345.6789", "12 345,6789",
                          "123,456.789", "123 456,789", "123,456,789.0123",
                          "123 456 789,0123" };
      CultureInfo[] cultures = { new CultureInfo("en-US"),
                                 new CultureInfo("fr-FR") }; 

      foreach (CultureInfo culture in cultures)
      {
         Console.WriteLine("String -> Decimal Conversion Using the {0} Culture",
                           culture.Name);
         foreach (string value in values)
         {
            Console.Write("{0,20}  ->  ", value);
            try {
               Console.WriteLine(Convert.ToDecimal(value, culture));
            }
            catch (FormatException) {
               Console.WriteLine("FormatException");
            }
         }
         Console.WriteLine();
      }                     
   }
}

I tried it with: "en-US" and "de-DE" ----- 1.234,56: US: FormatException; DE: 1234.56 -> OK ----- 1,234.56: US: 1234.56; DE: FormatException -> OK ----- 234.56: US: 234.56; DE: 23456 -> Not OK ----- 234,56: US: 23456; DE: 234.56 -> Not OK ----- Sorry, without line breaks it's a little bit confusing :/ — Beetee, Nov 19 '18 at 16:20

score 8 · Answer 3 · answered Dec 01 '11 at 13:04

If you know the culture that was in use when persisting the value, you can use it when parsing it, i.e.:

Convert.ToDecimal("133,3", System.Globalization.CultureInfo.GetCultureInfo("no"));

Of course, you are probably better off changing how the data is stored in the database, to use a floating point number of some form.

score 6 · Answer 4 · edited Apr 13 '12 at 09:15

6

Convert.ToDouble(textBox2.Text, new CultureInfo("uk-UA")).ToString(new CultureInfo("en-US"));

edited Apr 13 '12 at 09:15

Code Lღver

15,573
16
56
75

answered Apr 13 '12 at 05:47

Shrikant Prabhu

709
8
13

Welcome to stackoverflow! It's always better to provide a short description for a sample code to improve the post accuracy :) – Picrofo Software Oct 26 '12 at 05:45

score 2 · Answer 5 · answered Feb 27 '16 at 14:59

2

This solves your problem: .ToString(New CultureInfo("en-US"))

answered Feb 27 '16 at 14:59

Chris

21
2

score 1 · Answer 6 · answered Jun 23 '20 at 08:33

1

Hope it's helpful

double _number = 12536,8;

CultureInfo usCulture = new CultureInfo("en-US");

return _number.ToString("N", us);

answered Jun 23 '20 at 08:33

Adam

309
3
8

Anand Kumar · Answer 7 · 2011-12-02T17:09:53.200

used below code to fix my issue. I just hard coded the previous currency decimal part. may not be generic. but solved my problem.

public static decimal? ToDecimal1(this string source)
    {
        CultureInfo usCulture = new CultureInfo("en-US");

        if (string.IsNullOrEmpty(source.Trim1()))
            return null;
        else
            return Convert.ToDecimal(source.Replace(",", ".").Trim(), usCulture);
    }

How to convert "12,4" to decimal en-Us culture

7 Answers7

Linked

Related