How to set Million separator (') and thousand (.) using cultureinfo in C#

Question

I'm trying to convert a value 9.999.999 to 9'999.999 using cultureinfo in C# but I can't get it works.

How can I do that?

Hi, show us what you have tried. You are on the right track. — Stefan, Jun 22 '17 at 15:12
Is this something that you personally would like to see, or is this the usual way for the culture you are working for? — Hans Keﬆing, Jun 22 '17 at 15:27
I am not sure you can set different group separator in the same formatting with `CultureInfo`. I think you will have to do it with `Regex` or String operation (`String.Replace`, etc). Can you provide us more examples? (for example what do you expect for billions numbers?) — fharreau, Jun 22 '17 at 15:28
Which culture uses different separator for thousands an millions? — Martin Mulder, Jun 22 '17 at 15:35
i can imagine ... "the customer pays to be a special snowflake" — DarkSquirrel42, Jun 22 '17 at 15:57

score 2 · Answer 1 · answered Jun 22 '17 at 15:32

So it's a string and you want a different group-separator for first groups?

You could replace all but the last dot:

string value = "9.999.999";
StringBuilder sb = new StringBuilder(value);
bool skippedLast = false;

for (int i = sb.Length - 1; i >= 0; i--)
{
    if (sb[i] == '.')
    {
        if (!skippedLast)
            skippedLast = true;
        else
            sb[i] = '\'';
    }
}

string desiredOutput = sb.ToString(); // 9'999.999

DarkSquirrel42 · Answer 2 · 2017-06-22T16:06:39.833

1

since the default IFormatProvider implementations that are shipped with the framework lack the capability you want/need, I suggest implementing the interface yourself

additionally, since CultureInfo is not sealed, you can extend the class and provide your implementation to System.Threading.Thread.CurrentThread.CurrentCulture ... all consecutive formatting calls on that thread will use your implementation (unless called with a specific format provider...)

edited Jun 22 '17 at 16:06

answered Jun 22 '17 at 15:51

DarkSquirrel42

10,167
3
20
31

You also need the `ICustomFormatter`. Perhaps you want to add that to your answer. See: https://msdn.microsoft.com/en-us/library/system.icustomformatter(v=vs.110).aspx – Martin Mulder Jun 22 '17 at 20:59

How to set Million separator (') and thousand (.) using cultureinfo in C#

2 Answers2