Parsing currency to double raising exception

Question

I have a string which is "R$3.333,33" and I'm trying to parse it to a double value with this method:

public static BigDecimal parse(final String amount, final Locale locale) throws ParseException {
        final NumberFormat format = NumberFormat.getCurrencyInstance(locale);
        if (format instanceof DecimalFormat) {
            ((DecimalFormat) format).setParseBigDecimal(true);
        }
        return (BigDecimal) format.parse(amount.replaceAll("[^\\d.,]", ""));
    }

But I'm getting an exception that says:

W/System.err: java.text.ParseException: Unparseable number: "3.333,33" (at offset 8)

And I'm using it like:

Ferramentas.parse(value.getText().toString(), Locale.FRANCE)

Possible duplicate of [Converting different countrys currency to double using java](http://stackoverflow.com/questions/23990805/converting-different-countrys-currency-to-double-using-java) — marcelovca90, Oct 17 '16 at 23:38
@MarceloVinícius That answer doesn't work for `.` for thousands, it prints `3`. — m0skit0, Oct 17 '16 at 23:58

m0skit0 · Accepted Answer · 2016-10-18T20:55:42.580

2

The only solution I found is to replace . in your regex as well:

return (BigDecimal) format.parse(amount.replaceAll("[^\\d,]",""));

I haven't been able to parse a number with a . for thousands.

If you keep the . it gets parsed to 3.
If you replace the . by ,, it gets parsed to 3.333.

If anyone has a solution for the . for thousands, I would be really interested in hearing it.

edited Oct 18 '16 at 20:55

answered Oct 18 '16 at 00:24

m0skit0

25,268
11
79
127

marcelovca90 · Answer 2 · 2016-10-17T23:53:15.917

0

Take a look at this question and answer.

Although it looks like a duplicate, the parse method works if your input is "R$ 3.333,33" (notice the space between the currency symbol and the value).

To insert a space between the currency symbol and the value, you can use a method like this:

public static String insertSpaceBetweenSymbolAndValue(String s)
{
    int index = 0;
    while (index < s.length() && !Character.isDigit(s.charAt(index)))
        index++;
    return (index != s.length()) ? s.substring(0, index) + " " + s.substring(index) : s;
}

edited Oct 17 '16 at 23:53

answered Oct 17 '16 at 23:35

marcelovca90

2,673
3
27
34

how can I put that space between the value and the symbol? – AND4011002849 Oct 17 '16 at 23:42
@AND4011002849 Edited my answer to include such method. – marcelovca90 Oct 17 '16 at 23:53
Everything works fine from that answer until you add `.` for thousands. – m0skit0 Oct 17 '16 at 23:55
Are you keeping the `replaceAll()`? – m0skit0 Oct 18 '16 at 00:01
In fact, if I keep the `replaceAll()`, it does not get parsed. – marcelovca90 Oct 18 '16 at 00:04
If I remove the `replaceAll`, it does throw an exception `ParseException: Unparseable number: "$199.00"`. – m0skit0 Oct 18 '16 at 00:05
And btw the answer you link to does use replaceAll. Can you please just post the code you're using? – m0skit0 Oct 18 '16 at 00:06

score -2 · Answer 3 · answered Oct 18 '16 at 04:37

-2

Why not you remove 'R$ ', then parse your double?

String s = b.substring(3, b.length()); 
Double d = Double.valueOf(s);

answered Oct 18 '16 at 04:37

PLe

137
4

1

He's already removing R$: `amount.replaceAll("[^\\d.,]", "")`. – m0skit0 Oct 18 '16 at 14:28

Parsing currency to double raising exception

3 Answers3