Java NumberformatException with CSV long converting

Question

I'm trying to import a CSV file into Java, but when I reach the timestamp value (for instance: 135824328205) I get the following message:

02-25 10:40:48.629: W/System.err(23341): java.lang.NumberFormatException: 1.35998E+12

I would like to store it as a long value, but it isn't works, here is my code:

in.setTS(Long.parseLong(dataArray[2]));

Can anybody help me ? Thanks.

@PremGenError: it isn't. but if I open the csv with notepad I see the long value in there — narancs, Feb 25 '13 at 09:50
What is the contents of dataArray[2] and how are you getting it from the CSV file? — matt freake, Feb 25 '13 at 09:56
It looks like something is converting the plain integer value in your file, into an exponential String. You can use the answer below, to parse exponential values. Or if you're curious, track down whatever is converting your value. — matt freake, Feb 25 '13 at 10:15

score 1 · Accepted Answer · edited May 23 '17 at 11:49

1

As you can see here:

in.setTS(Double.valueOf(dataArray[2]).longValue());

in case dataArray[2] holds the relevant exponential notation as string

BigInteger can also help you here.

edited May 23 '17 at 11:49

Community

answered Feb 25 '13 at 09:49

BobTheBuilder

score 0 · Answer 2 · answered Feb 25 '13 at 09:52

0

For huge numbers it is highly useful to use BigInteger

BigInteger value = new BigInteger(dataArray[2], 10);

Assuming dataArray[2] is string

answered Feb 25 '13 at 09:52

asifsid88

2 Answers2