Examples of org.apache.commons.csv.CSVParser

org.apache.commons.csv.CSVParser
.ietf.org/html/rfc4180" target="_blank">RFC 4180 format.

To parse CSV input in a format like Excel, you write:
```
 CSVParser parser = CSVParser.parse(csvData, CSVFormat.EXCEL); for (CSVRecord csvRecord : parser) { ... } 
```
If the predefined formats don't match the format at hands, custom formats can be defined. More information about customising CSVFormats is available in {@link CSVFormat CSVFormat JavaDoc}.

Parsing into memory

If parsing record wise is not desired, the contents of the input can be read completely into memory.
```
 Reader in = new StringReader("a;b\nc;d"); CSVParser parser = new CSVParser(in, CSVFormat.EXCEL); List<CSVRecord> list = parser.getRecords(); 
```
There are two constraints that have to be kept in mind:
1. Parsing into memory starts at the current position of the parser. If you have already parsed records from the input, those records will not end up in the in memory representation of your CSV data.
2. Parsing into memory may consume a lot of system resources depending on the input. For example if you're parsing a 150MB file of CSV data the contents will be read completely into memory.
Notes

Internal parser state is completely covered by the format and the reader-state.
@version $Id: CSVParser.java 1617069 2014-08-10 08:53:42Z britter $ @see package documentation for more details


    //Read the first line of the file to determine table lay out.
    try {
      BufferedReader reader = new BufferedReader(new FileReader(file));


      setCsv(new CSVParser(reader, csvStrat));      


      this.line = csv.getLine();      


      //This block fills the table lay out array. Dependent on the value of Headerline,
      //Headerline = true use the values of the header line for the column names.

View Full Code Here

  public void AnalyseFile(File file) {


    try {


      BufferedReader reader = new BufferedReader(new FileReader(file));            
      setCsv(new CSVParser(reader, csvStrat));            


      //Set initial value for line
      this.line[0] = "Init";


      //skips first line if header line = true

View Full Code Here

            Reader reader = new InputStreamReader(stream, encoding);


            CSVStrategy strategy = new CSVStrategy(delimiter, '"', CSVStrategy.COMMENTS_DISABLED,
                            CSVStrategy.ESCAPE_DISABLED, false, false, false, false);


            CSVParser parser = new CSVParser(reader, strategy);


            for (int ii = 0; ii < skipLines; ii++)
                parser.getLine();


            List<String[]> values = new ArrayList<String[]>();
            String[] header = null;
            String[] line = parser.getLine();
            if (isFirstLineHeader)
            {
                header = line;
            }
            else
            {
                header = new String[line.length];
                for (int ii = 0; ii < header.length; ii++)
                    header[ii] = MessageFormat.format(Messages.CSVImportGenericColumnLabel, ii + 1);
                values.add(line);
            }


            while ((line = parser.getLine()) != null)
                values.add(line);


            this.columns = new CSVImporter.Column[header.length];
            for (int ii = 0; ii < header.length; ii++)
                this.columns[ii] = new Column(ii, header[ii]);

View Full Code Here

        if (delimiter != null) {
            strategy.setDelimiter(delimiter.charAt(0));
        }
        
        try {
            CSVParser parser = new CSVParser(in, strategy);
            List<List<String>> list = new ArrayList<List<String>>();
            while (true) {
                String[] strings = parser.getLine();
                if (strings == null) {
                    break;
                }
                List<String> line = Arrays.asList(strings);
                list.add(line);

View Full Code Here

      for (int i=0; i<skipLines; i++) {
        r.readLine();
      }
    }


    CSVParser parser = new CSVParser(reader, strategy);


    // parse the fieldnames from the header of the file
    if (fieldnames==null) {
      fieldnames = parser.getLine();
      if (fieldnames==null) {
        throw new SolrException( SolrException.ErrorCode.BAD_REQUEST,"Expected fieldnames in CSV input");
      }
      prepareFields();
    }


    // read the rest of the CSV file
    for(;;) {
      int line = parser.getLineNumber();  // for error reporting in MT mode
      String[] vals = parser.getLine();
      if (vals==null) break;


      if (vals.length != fields.length) {
        input_err("expected "+fields.length+" values but got "+vals.length, vals, line);
      }

View Full Code Here

      this.strategy = strategy;
      this.base = base;
    }


    void add(DocumentBuilder builder, int line, int column, String val) {
      CSVParser parser = new CSVParser(new StringReader(val), strategy);
      try {
        String[] vals = parser.getLine();
        if (vals!=null) {
          for (String v: vals) base.add(builder,line,column,v);
        } else {
          base.add(builder,line,column,val);
        }

View Full Code Here

    private CSVParser parser;
    private boolean hasHeaderLine = true;
    private String[] names = null;


    public CsvRecordReader(Reader reader) {
        this.parser = new CSVParser(reader);
    }

View Full Code Here

public class CsvColumnReader implements RecordReader {
    private CSVParser parser;
    private boolean hasHeaderLine = true;


    public CsvColumnReader(Reader reader) {
        this.parser = new CSVParser(reader);
    }

View Full Code Here

0 1 2 3 4 5 6 7

TOP

Related Classes of org.apache.commons.csv.CSVParser

Chapter05

com.netflix.astyanax.util.CsvColumnReader

com.netflix.astyanax.util.CsvRecordReader

de.apaxo.bedcon.FacebookRecommender

name.abuchen.portfolio.datatransfer.CSVImporter

net.sf.uadetector.DeviceCategoryExamplesReader

net.sf.uadetector.OperatingSystemExamplesReader

net.sf.uadetector.OperatingSystemSampleReader

net.sf.uadetector.UserAgentExamplesReader

org.apache.any23.extractor.csv.CSVReaderBuilder

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.

Examples of org.apache.commons.csv.CSVParser

Parsing into memory

Notes

Related Classes of org.apache.commons.csv.CSVParser