Separate between point and separator in decimal

Question

0.00/5 (No votes)

See more:

I making an app with C# and data stored in a file as decimal numbers. however, extracting these decimals giving a problem since I am working with two people which the first one has the English region and the other European region computer.
the problem is in the "decimal separator". the decimal number "3.466" as an example the English computer will read it as 3 with a fraction of 0.466 but the European region will read it as 3466 as a "three thousand four hundred and sixty-six". I had to change the file to the comma separator ",".
the "." is a thousand separator in the European region PC and vise versa in English PC.

how to unite these in such it does need to change the whole file for data. also when finish the app need to change the file for each region. if accidentally download the wrong region the app will not work properly.

any type of idea what code to solve this problem

What I have tried:

I change the file of data one to "." and other to "," separator manually for each region

Posted 30-Nov-20 10:37am

Member 12224804

Updated 30-Nov-20 11:07am

Add a Solution

Comments

Maciej Los 30-Nov-20 16:47pm

Have you ever heard about Globalization[^]?

PIEBALDconsult 30-Nov-20 18:10pm

Use JSON. Done.

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 · Accepted Answer · 2020-11-30T11:07:00

The various TryParse methods have optional overloads which support culture. For example: Double.TryParse Method (System) | Microsoft Docs[^]
If your app uses TryParse to try and read the value in European format and fails, it can retry using the UK format and see if that works.

But a better solution is not to store data in "human readable" format at all: read values in local format, convert them to numeric values, and store them as numbers. That way, the stored data is "culturally agnostic" and can be displayed or input in whatever local format is selected by the computer user.
Storing it in "local" format is a bad idea and should be stamped on, and out!