Android In dutch language comma (,) is interpreted as dot (.)

Question

I am using the following code to format the amount entered by user in EditText.

fun String.formatWithComma(): String {
    return try {
        val formatter = DecimalFormat("#,###,###")
        formatter.format(toDouble())
    } catch (ex: Exception) {
        return ""
    }
}

But when I switch the phone language to dutch, the comma is converted to dot (.). Like if user wants to type 4,323 , it is converted to 4.323.

I want to comma instead of dot even in dutch language. Any solution

What's your question? Dutch uses comma as a decimal separator and dot as a thousands separator, so this behavior is correct. — Robby Cornelissen, May 23 '22 at 06:16

score 1 · Answer 1 · answered May 23 '22 at 07:08

1

Some European countries use comma and dot in the different way than USA and England. You should add an extra line to instruct it before you use it:

formatter.decimalFormatSymbols = DecimalFormatSymbols.getInstance(Locale.ENGLISH)

answered May 23 '22 at 07:08

AIMIN PAN

1,563
1
9
13

score 0 · Answer 2 · answered May 23 '22 at 06:56

I am not sure, if this will fix your problem.

println("${"4.323.001".formatWithComma()}")

If we found multiple dots in the string, I am replacing that values, Improve this solution based on your needs.

fun String.formatWithComma(): String {
    return try {
        var lastIndexOf = this.lastIndexOf(".");
        var temp = this
        var temp2 = ""
        if(this.split(".").size >= 2)
        {
        temp = this.substring(0,lastIndexOf).replace(".","");
        temp2 = this.substring(lastIndexOf,this.length);    
        }
        
        val formatter = DecimalFormat("#,###,###.###")
        return formatter.format((temp+temp2).toDouble())
    } catch (ex: Exception) {
        return ""
    }
}

thanks for your solution but this solution works in case of 4.323.001 type of string only. Not works in 4,323.001 — Bilal Bangash, May 23 '22 at 07:14
4,323.001 it perfect string, you wan't to replace that last dot ? — Ashvin solanki, May 23 '22 at 07:17

score 0 · Answer 3 · answered May 23 '22 at 07:23

On the basis of answer given by AIMIN PAN

Final solution to fix this issue is

fun String.formatWithComma(): String {
    return try {
        val formatter = DecimalFormat("#,###,###")
        formatter.decimalFormatSymbols = DecimalFormatSymbols.getInstance(Locale.ENGLISH)
        formatter.format(toDouble())
    } catch (ex: Exception) {
        return ""
    }
}

Android In dutch language comma (,) is interpreted as dot (.)

3 Answers3