Thursday, 12 September 2013

java.lang.NumberFormatException: For input string: "1,167.40"

java.lang.NumberFormatException: For input string: "1,167.40"

I'm reading data from CSV file. One of the fields contains the value
1,167.40. The code piece for reading this field is the following:
String csvFilename = "TEST_FILE.csv";
CSVReader csvReader = new CSVReader(new FileReader(csvFilename));
String[] row = null;
csvReader.readNext(); // to skip the headers
while((row = csvReader.readNext()) != null)
{
double val = Double.parseDouble(row[0]); // !!!
}
csvReader.close();
The line double val = Double.parseDouble(row[0]) results in the following
error message:
java.lang.NumberFormatException: For input string: "1,167.40"
How to solve this issue?
P.S. For other values like 111.64 this error does not appear.

No comments:

Post a Comment