DecimalFormat.applyPattern("#.##0,00") throwing an exception

java decimalformat
David Thielen picture David Thielen · Feb 24, 2017 · Viewed 7.7k times · Source

For the code:

DecimalFormat df = (DecimalFormat) NumberFormat.getNumberInstance(locale);
df.applyPattern("#.##0,00");

And it throws an IllegalArgumentException with a message of Malformed pattern "#.##0,00"

What is wrong with this?

Edit: I want to use the . as a thousands separator and , as the decimal. I know that's ass-backwards but have a case where that's the format they want.

Answer

john16384 picture john16384 · Feb 25, 2017

You need to use the pattern "#,##0.##" to indicate where you want to decimal separator and the thousand seperator. The Locale you use when using this DecimalFormat will then determine if the decimal separator is a . or , -- the pattern should NOT be changed.

If you are not getting the correct separators, you will need to use a different Locale.

Related questions

How can I truncate a double to only two decimal places in Java?

For example I have the variable 3.545555555, which I would want to truncate to just 3.54.

Read More
How to change the decimal separator of DecimalFormat from comma to dot/point?

I have this little crazy method that converts BigDecimal values into nice and readable Strings. private String formatBigDecimal(BigDecimal bd){ DecimalFormat df = new DecimalFormat(); df.setMinimumFractionDigits(3); df.setMaximumFractionDigits(3); df.setMinimumIntegerDigits(1); df.setMaximumIntegerDigits(3); df.setGroupingSize(20); return df.format(bd); } It however, …

Read More
How can I parse a String to BigDecimal?

I have this String: 10,692,467,440,017.120 (it's an amount). I want to parse it to a BigDecimal. The problem is that I have tried both DecimalFormat and NumbeFormat in vain.

Read More