CsvParserSettings parserSettings = new CsvParserSettings(); // Let's extract headers parserSettings.setHeaderExtractionEnabled(true); parserSettings.selectFields("Field 5", "Field 1"); //Rows will come organized according to your field selection List<String[]> allRows = parser.parseAll("path/to/file.csv");
BeanListProcessor<SUREDataBean> rowProcessor = new BeanListProcessor<SUREDataBean>(SUREDataBean.class); CsvParserSettings parserSettings = new CsvParserSettings(); settings.getFormat().setDelimiter('|'); parserSettings.setRowProcessor(rowProcessor); parserSettings.setHeaderExtractionEnabled(true); CsvParser parser = new CsvParser(parserSettings); //Parsing is started here. //this submits all rows parsed from the input to the BeanListProcessor parser.parse(new FileReader(new File("/examples/bean_test.csv"))); List<SUREDataBean> beans = rowProcessor.getBeans();
BeanListProcessor<TestBean> rowProcessor = new BeanListProcessor<TestBean>(TestBean.class); CsvParserSettings parserSettings = new CsvParserSettings(); parserSettings.setRowProcessor(rowProcessor); parserSettings.setHeaderExtractionEnabled(true); CsvParser parser = new CsvParser(parserSettings); //And parse! //this submits all rows parsed from the input to the BeanListProcessor parser.parse(new FileReader(new File("/examples/bean_test.csv"))); List<TestBean> beans = rowProcessor.getBeans();
CsvParserSettings parserSettings = new CsvParserSettings(); //parser config with many options, check the tutorial parserSettings.setHeaderExtractionEnabled(true); // uses the first row as headers // To get the values of all columns, use a column processor ColumnProcessor rowProcessor = new ColumnProcessor(); parserSettings.setRowProcessor(rowProcessor); CsvParser parser = new CsvParser(parserSettings); //This will parse everything and pass the data to the column processor parser.parse(new FileReader(new File("/path/to/your/file.csv"))); //Finally, we can get the column values: Map<String, List<String>> columnValues = rowProcessor.getColumnValuesAsMapOfNames();
BeanListProcessor<Employee> rowProcessor = new BeanListProcessor<Employee>(Employee.class); CsvParserSettings parserSettings = new CsvParserSettings(); parserSettings.setRowProcessor(rowProcessor); parserSettings.setHeaderExtractionEnabled(true); CsvParser parser = new CsvParser(parserSettings); //And parse! //this submits all rows parsed from the input to the BeanListProcessor parser.parse(new FileReader(new File("/path/to/your.csv"))); List<Employee> beans = rowProcessor.getBeans();
// BeanListProcessor converts each parsed row to an instance of a given class, then stores each instance into a list. BeanListProcessor<SubscriberPackages> rowProcessor = new BeanListProcessor<SubscriberPackages>(SubscriberPackages.class); CsvParserSettings parserSettings = new CsvParserSettings(); //many options here, check the tutorial. parserSettings.setRowProcessor(rowProcessor); //uses the bean processor to handle your input rows parserSettings.setHeaderExtractionEnabled(true); // extracts header names from the input file. CsvParser parser = new CsvParser(parserSettings); //creates a parser with your settings. parser.parse(new FileReader(new File("/path/to/file.csv"))); //all rows parsed here go straight to the bean processor // The BeanListProcessor provides a list of objects extracted from the input. List<SubscriberPackages> beans = rowProcessor.getBeans();
CsvParserSettings parserSettings = new CsvParserSettings(); parserSettings.setHeaderExtractionEnabled(true); parserSettings.selectFields("f", "w", "b"); CsvParser parser = new CsvParser(parserSettings); List<String[]> parsedRows = parser.parseAll(newFileReader("test.csv"));
CsvParserSettings settings = new CsvParserSettings(); //many options here, check the tutorial. // turns on automatic detection of line separators, // column separators, quotes & quote escapes settings.detectFormatAutomatically(); // configures to skip a number of rows from the input and start parsing from there settings.setNumberOfRowsToSkip(3); // configures the parser to extract headers from the first parsed row settings.setHeaderExtractionEnabled(true); CsvParser parser = new CsvParser(settings); List<String[]> rows = parser.parseAll(new File("/path/to/your/file.csv"));
// BeanListProcessor converts each parsed row to an instance of a given class, then stores each instance into a list. BeanListProcessor<TestBean> rowProcessor = new BeanListProcessor<TestBean>(TestBean.class); CsvParserSettings parserSettings = new CsvParserSettings(); parserSettings.setRowProcessor(rowProcessor); //Uses the first valid row of the CSV to assign names to each column parserSettings.setHeaderExtractionEnabled(true); CsvParser parser = new CsvParser(parserSettings); parser.parse(new FileReader(yourFile)); // The BeanListProcessor provides a list of objects extracted from the input. List<TestBean> beans = rowProcessor.getBeans();
BeanListProcessor<TestBean> rowProcessor = new BeanListProcessor<TestBean>(TestBean.class); CsvParserSettings parserSettings = new CsvParserSettings(); parserSettings.setRowProcessor(rowProcessor); parserSettings.setHeaderExtractionEnabled(true); CsvParser parser = new CsvParser(parserSettings); parser.parse(new FileReader(Paths.get("list2.csv").toFile()); // The BeanListProcessor provides a list of objects extracted from the input. List<TestBean> beans = rowProcessor.getBeans();
CsvParserSettings parserSettings = new CsvParserSettings(); // Let's extract headers parserSettings.setHeaderExtractionEnabled(true); // To get the values of all columns, use a column processor ColumnProcessor rowProcessor = new ColumnProcessor(); parserSettings.setRowProcessor(rowProcessor); CsvParser parser = new CsvParser(parserSettings); //This will kick in our column processor parser.parse(new FileReader("path/to/file.csv")); //Finally, we can get the column values: Map<String, List<String>> columnValues = rowProcessor.getColumnValuesAsMapOfNames();
public <T> List<T> parseBeans(Class<T> beanType, File inputFile){ BeanListProcessor<T> rowProcessor = new BeanListProcessor<T>(beanType); CsvParserSettings parserSettings = new CsvParserSettings(); parserSettings.setRowProcessor(rowProcessor); parserSettings.setHeaderExtractionEnabled(true); //will get headers from the input file CsvParser parser = new CsvParser(parserSettings); //this will read your file and submit all rows to the row processor defined above parser.parse(new FileReader(inputFile)); List<T> beans = rowProcessor.getBeans(); return beans; }
BeanListProcessor<TestBean> rowProcessor = new BeanListProcessor<TestBean>(TestBean.class); CsvParserSettings parserSettings = new CsvParserSettings(); parserSettings.setRowProcessor(rowProcessor); parserSettings.setHeaderExtractionEnabled(true); CsvParser parser = new CsvParser(parserSettings); parser.parse(getReader("/examples/bean_test.csv")); List<TestBean> beans = rowProcessor.getBeans();
BeanListProcessor<TestBean> rowProcessor = new BeanListProcessor<TestBean>(TestBean.class); CsvParserSettings parserSettings = new CsvParserSettings(); parserSettings.setRowProcessor(rowProcessor); parserSettings.setHeaderExtractionEnabled(true); CsvParser parser = new CsvParser(parserSettings); parser.parse(getReader("/examples/bean_test.csv")); List<TestBean> beans = rowProcessor.getBeans();
ObjectRowListProcessor rowProcessor = new ObjectRowListProcessor(); rowProcessor.convertFields(Conversions.toBoolean("yes", "no")).set("metformin-rosiglitazone","metformin-pioglitazone","change","diabetesMed","readmitted")); //and all other fields where this makes sense. rowProcessor.convertFields(Conversions.toLowerCase(), Conversions.toNull("none", "?")).set("another field", "and another field"); CsvParserSettings parserSettings = new CsvParserSettings(); parserSettings.setRowProcessor(rowProcessor); parserSettings.setHeaderExtractionEnabled(true); CsvParser parser = new CsvParser(parserSettings); //the rowProcessor will be executed here. parser.parse(YOUR_INPUT_HERE); List<Object[]> rows = rowProcessor.getRows();
CsvParserSettings settings = new CsvParserSettings(); //many options here, check the tutorial settings.getFormat().setLineSeparator("\r\n"); settings.getFormat().setNormalizedNewline('\u0001'); //uses a special character to represent a new record instead of \n. settings.setNormalizeLineEndingsWithinQuotes(false); //does not replace \r\n by the normalized new line when reading quoted values. settings.setHeaderExtractionEnabled(true); //extract headers from file settings.trimValues(false); //does not remove whitespaces around values CsvParser parser = new CsvParser(settings); List<Record> recordsList = parser.parseAllRecords(new File("201404051539.csv"));
// BeanListProcessor converts each parsed row to an instance of a given class, then stores each instance into a list. BeanListProcessor<TestBean> rowProcessor = new BeanListProcessor<TestBean>(TestBean.class); CsvParserSettings parserSettings = new CsvParserSettings(); parserSettings.setRowProcessor(rowProcessor); parserSettings.setHeaderExtractionEnabled(true); CsvParser parser = new CsvParser(parserSettings); parser.parse(getReader("/examples/bean_test.csv")); // The BeanListProcessor provides a list of objects extracted from the input. List<TestBean> beans = rowProcessor.getBeans();
CsvParserSettings parserSettings = new CsvParserSettings(); //many options here, check the documentation. parserSettings.setHeaderExtractionEnabled(true); // gets the headers from the first row // To get the values of all columns, use a column processor ColumnProcessor rowProcessor = new ColumnProcessor(); parserSettings.setRowProcessor(rowProcessor); CsvParser parser = new CsvParser(parserSettings); //This will parse all rows and submit them to the column processor parser.parse(newFileReader("test.csv")); //Finally, we can get the column values: Map<String, List<String>> columnValues = rowProcessor.getColumnValuesAsMapOfNames();
CsvParserSettings parserSettings = new CsvParserSettings(); parserSettings.getFormat().setLineSeparator("\n"); parserSettings.getFormat().setDelimiter('$'); parserSettings.setHeaderExtractionEnabled(true); // To get the values of all columns, use a column processor ColumnProcessor rowProcessor = new ColumnProcessor(); parserSettings.setRowProcessor(rowProcessor); CsvParser parser = new CsvParser(parserSettings); //This will kick in our column processor parser.parse(new FileReader("testing.cvs")); //Finally, we can get the column values: Map<String, List<String>> columnValues = rowProcessor.getColumnValuesAsMapOfNames();
private Iterable<Record> getItererableCsv(String source, LogicalSource logicalSource) { CsvParserSettings settings = new CsvParserSettings(); settings.setHeaderExtractionEnabled(true); settings.setLineSeparatorDetectionEnabled(true); settings.setDelimiterDetectionEnabled(true); settings.setReadInputOnSeparateThread(true); CsvParser parser = new CsvParser(settings); return parser.iterateRecords(new StringReader(source)); }