Java Convert String into BigDecimal

Question

I have to convert a String (read from excel cell) into BigDecimal, but I have to consider :

the BigDecimal number will have two decimal digits, so I must form it in that way
the original string could use comma (",") as decimal separator (and this is my greater problem because if I write BigDecimal num = new BigDecimal(rowCell); and rowCell has comma as decimal separator I will take an exception...)

Could you help me? Thank you in advance

"the original string could use comma": could or will? — ernest_k
– ernest_k, Commented Jun 20, 2018 at 8:17
"Could". Because some users will use dot but I must be able to predict the use of the comma. Thank yuo for the help — Raul
– Raul, Commented Jun 20, 2018 at 8:21
This answer will help you in this situation: How to parse number string containing commas into an integer in java? — Sandeep Kokate
– Sandeep Kokate, Commented Jun 20, 2018 at 8:23

azro · Accepted Answer · 2018-06-20 08:35:39Z

2

You need to do it by steps:

replace the comma , by a dot .
get a BigDecimal from this new string
round it to 2 decimals with ROUND_DOWN or ROUND_UP

String str = "123,456";                   // String 132,456
str = str.replace(',', '.');              // String 132.456
BigDecimal b = new BigDecimal(str);       // BigDec 132.456
b = b.setScale(2, BigDecimal.ROUND_DOWN); // BigDec 132.45

If you concat you have :

String str = "123,456";                  
BigDecimal b = new BigDecimal(str.replace(',', '.')).setScale(2, BigDecimal.ROUND_DOWN);

Working DEMO

answered Jun 20, 2018 at 8:35

azro

54.2k9 gold badges38 silver badges75 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

azro Over a year ago

@Lorenzo elegant ? You can print flowers around if you want^^

Vitalii Vitrenko · Accepted Answer · 2018-06-20 08:31:17Z

0

Just replace a comma with a dot. It's simple and fast enough.

BigDecimal num = new BigDecimal(rowCell.replace(',', '.'));

answered Jun 20, 2018 at 8:31

Vitalii Vitrenko

10.6k5 gold badges48 silver badges69 bronze badges

Collectives™ on Stack Overflow

Java Convert String into BigDecimal

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related