How do I convert this european number format?

Question

0.00/5 (No votes)

See more:

If the user enters - 6,500.20, would this then be converted to 6.50020?

What I have tried:

C#

double convertedValue;
            if (double.TryParse(value, out convertedValue))
            {
                return convertedValue;
            }

Output - 6500.20, but I need 6.50020

Posted 14-Feb-22 18:35pm

User 14677492

Updated 15-Feb-22 10:07am

Sean Ewington

v3

Add a Solution

Comments

[no name] 15-Feb-22 2:14am

here 6,5000.20 is in european
six thousand five hundred tonnes and 20 kilo's
i need to store as 6.50020

Maciej Los 15-Feb-22 11:18am

Well, as far as i know, six thousand five hundred tonnes and 20 kilos is equal to 6520, instead of 650020.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2022-02-14T19:56:00

Solution 1

Depends on the setting on your particular machine: 6,500.20 in the UK would be six thousand five hundred point 2.
But in Germany, the dot and comma are reversed: six point five zero zero two.

To read a number in a specific format, use the TryParse overload that allows you to specify the culture: TryParse(String, NumberStyles, IFormatProvider, Double)[^]

Posted 14-Feb-22 19:56pm

OriginalGriff

Comments

[no name] 15-Feb-22 2:14am

here 6,5000.20 is in european
six thousand five hundred tonnes and 20 kilo's
i need to store as 6.50020

OriginalGriff 15-Feb-22 2:48am

And?
What is stopping you from doing that?

I'm not trying to be awkward, you just aren't giving us any information - remember that we can't see your screen, access your HDD, or read your mind - we only get exactly what you type to work with - we get no other context for your project.

[no name] 15-Feb-22 3:56am

which cultureinfo i need to use. i tried "en-GB", "fr-FR" and es-ES but nothing worked. i need the output as 6.50020 but i am getting 6500.20

OriginalGriff 15-Feb-22 4:08am

It works for me:

            string inp = "6,500.20";
            double result;
            if (double.TryParse(inp, NumberStyles.Any, new CultureInfo("en-GB"), out result))
                {
                Console.WriteLine(result);
                }

Prints "6500.2"

What does it give you?

[no name] 15-Feb-22 4:12am

Gives the same but i need 6.50020

lmoelleb 15-Feb-22 4:36am

Then divide by 1000 as that is how you convert kilos to ton. It is a unit conversion and has nothing to do with decimal separators so don't try to solve these two very unrelated topics as one "problem". Once you have the result you expect then use it as is (double, decimal, float) or - if you need it as a string - use ToString specifying format and cultureinfo again.

OriginalGriff 15-Feb-22 4:44am

It's a number, not a string: it doesn't "preserve" leading or trailing zeros - if you want them, you have to format the number to provide them when you convert it to a string for presentation (to the user, or a text file, etc.)

What exactly are you trying to do this for?

lmoelleb 15-Feb-22 4:09am

https://en.wikipedia.org/wiki/Decimal_separator contains a list of countries. I would expect UK to work though, so debug and check what is going on - and if it does not work, post a SINGLE line of code with your call to TryParse showing a hard coded CultureInfo name and input string!

lmoelleb 15-Feb-22 3:08am

It is one of the European formats. Not "the European" format. There is more than one country in Europe, and they don't all use the same format. That is why you have to tell it which country rules to use. Sure, if you are 100% sure this is the specific format used, you can just hard code any of the countries/languages that use the desired format - for example German. But don't for a second think doing this means "now it works in Europe". Unfortunately humans managed to make this complicated long before computers where invented.