Can't parse value from CSV to Double

Question

My problem is to parse value from CSV to double. I can't understand why I can parse all values from columns A-BJ and when I have column BK java throw error

Exception in thread "main" java.lang.NumberFormatException: For input string: "4,69E+12" at sun.misc.FloatingDecimal.readJavaFormatString(Unknown Source) at sun.misc.FloatingDecimal.parseDouble(Unknown Source) at java.lang.Double.parseDouble(Unknown Source) at Compare.normalizacja_dziesietna(Compare.java:68) at Compare.main(Compare.java:138)

For example in columnt BE there is also o big number and there is no problem with parsing...

Here there is a screenshot of the file https://pasteboard.co/HVkMt4L.png

It's treating the value as a String so you're trying to parse "4,96E+12" as a Double which isn't valid. Make sure the column is formatted as a number and check the value of the raw CSV file in a text editor. — David Billings
– David Billings, Commented Jan 7, 2019 at 11:38

ygor · Accepted Answer · 2019-01-07 11:39:18Z

1

Double.parseDouble expects 4.69E+12 instead of 4,69E+12.

Example:

Double.parseDouble("4,69E+12".replaceAll(",", "\\."));

answered Jan 7, 2019 at 11:39

ygor

1,7661 gold badge12 silver badges24 bronze badges

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

Comments

StefanE · Accepted Answer · 2019-01-07 11:39:22Z

0

You should use BigDecimal instead.

Collectives™ on Stack Overflow

Can't parse value from CSV to Double

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related