private CsvFormat csvFormat(CsvReadOptions options) { CsvFormat format = new CsvFormat(); if (options.separator() != null) { format.setDelimiter(options.separator()); } if (options.lineEnding() != null) { format.setLineSeparator(options.lineEnding()); } return format; }
/** * Private constructor to prevent instantiation */ public CsvWriter(Table table, CsvWriteOptions options) { this.table = table; this.header = options.header(); this.writer = options.writer(); this.settings = new CsvWriterSettings(); // Sets the character sequence to write for the values that are null. settings.setNullValue(nullValue); settings.getFormat().setDelimiter(options.separator()); settings.getFormat().setQuote(options.quoteChar()); settings.getFormat().setQuoteEscape(options.escapeChar()); settings.getFormat().setLineSeparator(options.lineEnd()); // writes empty lines as well. settings.setSkipEmptyLines(false); }
public CSVDataFrameWriter(String fieldDelimiter, String lineDelimiter) { this(); this.format.setDelimiter(fieldDelimiter.charAt(0)); this.format.setLineSeparator(lineDelimiter); }
private void init(String filename) { CsvParserSettings settings = new CsvParserSettings(); settings.getFormat().setLineSeparator("\n"); CsvParser csvParser = new CsvParser(settings); csvParser.beginParsing(getReader(filename)); this.parser = csvParser; }
private CsvFormat csvFormat(CsvReadOptions options) { CsvFormat format = new CsvFormat(); if (options.separator() != null) { format.setDelimiter(options.separator()); } if (options.lineEnding() != null) { format.setLineSeparator(options.lineEnding()); } return format; }
public <T> List<T> getRows(String lineSep, String delimiter, CsvRowMapper<T> rowMapper) { CsvParserSettings settings = new CsvParserSettings(); settings.getFormat().setLineSeparator(lineSep); settings.getFormat().setDelimiter(delimiter.charAt(0)); RowListProcessor rowProcessor = new RowListProcessor(); settings.setProcessor(rowProcessor); CsvParser parser = new CsvParser(settings); parser.beginParsing(targetFile); List<T> rows = new ArrayList<>(); String[] row; int rowNumber = 1; while ((row = parser.parseNext()) != null) { T mappedRow = rowMapper.mapRow(rowNumber, row); if(mappedRow != null) { rows.add(rowMapper.mapRow(rowNumber, row)); } rowNumber++; } parser.stopParsing(); return rows; }
/** * 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; }
/** * Provides a basic CSV configuration that allows writing CSV files that can be read by Microsoft Excel. * * @return a pre-configured {@link CsvWriterSettings} object with suggested settings for generating * CSV files that can be read by Microsoft Excel. */ public static CsvWriterSettings writeExcel() { CsvWriterSettings settings = new CsvWriterSettings(); settings.getFormat().setLineSeparator("\r\n"); settings.getFormat().setComment('\0'); settings.setEmptyValue(null); settings.setSkipEmptyLines(false); settings.trimValues(false); return settings; }
settings.setMaxColumns(65535); settings.setMaxCharsPerColumn(65535); settings.getFormat().setLineSeparator(loadData.getLineTerminatedBy()); settings.getFormat().setDelimiter(loadData.getFieldTerminatedBy().charAt(0)); if (loadData.getEnclose() != null) {
settings.getFormat().setLineSeparator(lineSep); settings.getFormat().setDelimiter(delimiter.charAt(0)); settings.setHeaderExtractionEnabled(firstHeaderRow);
settings.setMaxColumns(65535); settings.setMaxCharsPerColumn(65535); settings.getFormat().setLineSeparator(loadData.getLineTerminatedBy()); settings.getFormat().setDelimiter(loadData.getFieldTerminatedBy().charAt(0)); if (loadData.getEnclose() != null) {
/** * Returns the CSV format detected when one of the following settings is enabled: * <ul> * <li>{@link CommonParserSettings#isLineSeparatorDetectionEnabled()}</li> * <li>{@link CsvParserSettings#isDelimiterDetectionEnabled()}</li> * <li>{@link CsvParserSettings#isQuoteDetectionEnabled()}</li> * </ul> * * The detected format will be available once the parsing process is initialized (i.e. when {@link AbstractParser#beginParsing(Reader) runs}. * * @return the detected CSV format, or {@code null} if no detection has been enabled or if the parsing process has not been started yet. */ public final CsvFormat getDetectedFormat() { CsvFormat out = null; if (settings.isDelimiterDetectionEnabled()) { out = settings.getFormat().clone(); out.setDelimiter(this.delimiter); } if (settings.isQuoteDetectionEnabled()) { out = out == null ? settings.getFormat().clone() : out; out.setQuote(quote); out.setQuoteEscape(quoteEscape); } if (settings.isLineSeparatorDetectionEnabled()) { out = out == null ? settings.getFormat().clone() : out; out.setLineSeparator(input.getLineSeparator()); } return out; }
/** * Private constructor to prevent instantiation */ public CsvWriter(Table table, CsvWriteOptions options) { this.table = table; this.header = options.header(); this.writer = options.writer(); this.settings = new CsvWriterSettings(); // Sets the character sequence to write for the values that are null. settings.setNullValue(nullValue); settings.getFormat().setDelimiter(options.separator()); settings.getFormat().setQuote(options.quoteChar()); settings.getFormat().setQuoteEscape(options.escapeChar()); settings.getFormat().setLineSeparator(options.lineEnd()); // writes empty lines as well. settings.setSkipEmptyLines(false); }