How can I parse a String to BigDecimal?

Question

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.

Show us what you have tried. We'll help – Tala Aug 14 '13 at 12:33 — Tala, Aug 14 '13 at 12:33

score 79 · Accepted Answer · edited Jun 04 '15 at 16:31

Try this

// Create a DecimalFormat that fits your requirements
DecimalFormatSymbols symbols = new DecimalFormatSymbols();
symbols.setGroupingSeparator(',');
symbols.setDecimalSeparator('.');
String pattern = "#,##0.0#";
DecimalFormat decimalFormat = new DecimalFormat(pattern, symbols);
decimalFormat.setParseBigDecimal(true);

// parse the string
BigDecimal bigDecimal = (BigDecimal) decimalFormat.parse("10,692,467,440,017.120");
System.out.println(bigDecimal);

If you are building an application with I18N support you should use DecimalFormatSymbols(Locale)

Also keep in mind that decimalFormat.parse can throw a ParseException so you need to handle it (with try/catch) or throw it and let another part of your program handle it

If the grouping and decimal separator are switched the above code will not work. It will work if DecimalFormat is initialized as it follows `DecimalFormat res = new DecimalFormat(); res.setDecimalFormatSymbols(symbols); res.applyLocalizedPattern(formatter);` — raisercostin, Jan 18 '21 at 09:22

score 27 · Answer 2 · answered Aug 14 '13 at 12:36

27

Try this

 String str="10,692,467,440,017.120".replaceAll(",","");
 BigDecimal bd=new BigDecimal(str);

answered Aug 14 '13 at 12:36

Ruchira Gayan Ranaweera

33,712
16
72
110

@jlordo yes I edited my answer – Ruchira Gayan Ranaweera Aug 14 '13 at 12:38

score 16 · Answer 3 · edited Sep 05 '15 at 11:06

16

Try the correct constructor http://docs.oracle.com/javase/7/docs/api/java/math/BigDecimal.html#BigDecimal(java.lang.String)

You can directly instanciate the BigDecimal with the String ;)

Example:

BigDecimal bigDecimalValue= new BigDecimal("0.5");

edited Sep 05 '15 at 11:06

Taner

4,485
3
17
14

answered Aug 14 '13 at 12:35

Rene M.

2,549
12
23

BigDecimal can not parse the example string. – Tarynn Sep 08 '16 at 14:42
It will fail for the string value: `1,000` commas are not taking care in construction conversion. – Zubair Ahmed Feb 06 '20 at 17:25

score 13 · Answer 4 · answered Aug 14 '13 at 12:33

BigDecimal offers a string constructor. You'll need to strip all commas from the number, via via an regex or String filteredString=inString.replaceAll(",","").

You then simply call BigDecimal myBigD=new BigDecimal(filteredString);

You can also create a NumberFormat and call setParseBigDecimal(true). Then parse( will give you a BigDecimal without worrying about manually formatting.

How can I parse a String to BigDecimal?

4 Answers4

Linked