CsvParserSettings parserSettings = new CsvParserSettings(); parserSettings.setParseUnescapedQuotes(true); //this is enabled by default CsvParser parser = new CsvParser(parserSettings); List<String[]> allRows = parser.parseAll(getReader("/examples/bean_test.csv"));
CsvParserSettings settings = new CsvParserSettings(); settings.getFormat().setLineSeparator("\r\n"); settings.setParseUnescapedQuotes(true); // THIS IS IMPORTANT FOR YOU CsvParser parser = new CsvParser(settings);
/** * Provides a basic CSV configuration that allows parsing CSV files produced by Microsoft Excel. * * @return a pre-configured {@link CsvParserSettings} object with suggested settings * for parsing CSV files produced by Microsoft Excel. */ public static CsvParserSettings parseExcel() { CsvParserSettings settings = new CsvParserSettings(); settings.getFormat().setLineSeparator("\r\n"); settings.getFormat().setComment('\0'); settings.setParseUnescapedQuotes(false); settings.setSkipEmptyLines(false); settings.trimValues(false); return settings; }