OpenCSV读取带千分位逗号的数值字符串：还原真实值及排查异常

Let’s tackle this problem step by step—first figuring out why your CSV read is returning an unexpected value, then how to convert those comma-formatted numeric strings to proper values.

The 13,142.40 output instead of your expected 60,691.32 is almost certainly due to one of these common issues:

• Fix your file path (critical!):
  You’re missing a path separator between your user directory and filename. This means your code is probably reading a wrong (or older) CSV file entirely. Update your path code to avoid this:

  // Safer way using Paths to handle separators automatically
  String path = Paths.get(System.getProperty("user.dir"), "thecsv.csv").toString();
  // Or manually add the separator:
  // String path = System.getProperty("user.dir") + "/thecsv.csv";
  

• Verify your CSV structure and indices:
  OpenCSV uses zero-based indexing, so csvBody.get(2) is the third row and [1] is the second column of that row. It’s easy to mix up rows/columns or misassume where your data lives. Print the full CSV content to confirm:

  for (int rowIdx = 0; rowIdx < csvBody.size(); rowIdx++) {
      String[] row = csvBody.get(rowIdx);
      System.out.printf("Row %d: %s%n", rowIdx, String.join(" | ", row));
  }
  

  This will show you exactly what’s in each row and column, so you can confirm if 60,691.32 is really at position [2][1].

• Check delimiter and quoting issues:
  If your CSV doesn’t wrap values with commas (like 75,624.32) in quotes, OpenCSV’s default comma delimiter will split that value into two columns. That completely breaks your column indices. Fix this by either:

  • Ensuring your CSV uses quotes around numeric values with commas (e.g., "ACV: 75,624.32"), or
  • Using a different delimiter (like semicolon) when writing the CSV, and initializing CSVReader with that delimiter:

    CSVReader csvReader = new CSVReaderBuilder(reader).withSeparator(';').build();
    

Once you’re correctly fetching the target string (e.g., "60,691.32"), use NumberFormat with the appropriate locale to parse it into a numeric type. For US-style thousand separators and decimal points, use Locale.US:

import java.text.NumberFormat;
import java.text.ParseException;
import java.util.Locale;
import java.math.BigDecimal;

// First, strip any non-numeric labels if needed (e.g., "ARR: ")
String rawStr = csvBody.get(2)[1].replaceAll("[^0-9.,]", "");
NumberFormat usNumberFormat = NumberFormat.getInstance(Locale.US);

try {
    Number parsedNum = usNumberFormat.parse(rawStr);
    
    // Use double if precision isn't critical (e.g., general stats)
    double doubleValue = parsedNum.doubleValue();
    System.out.println("Double value: " + doubleValue); // Outputs 60691.32
    
    // Use BigDecimal for precise financial/currency calculations (better for ACV/TCV/ARR)
    BigDecimal preciseValue = new BigDecimal(parsedNum.toString());
    System.out.println("Precise value: " + preciseValue); // Outputs 60691.32
} catch (ParseException e) {
    System.err.println("Failed to parse string: " + rawStr);
    e.printStackTrace();
}

This handles the thousand separators correctly and gives you a usable numeric value for calculations.

内容的提问来源于stack exchange，提问作者SteroidKing666