Parser for CSV with headers on multiple lines using Java

Question

Is there a Java library that would allow me to parse CSV files that have headers defined on multiple lines? Here's an example for such a CSV :

$ID$,$Customer$

Cust1, Jack

Cust2 , Rose

$Name$,$Location$

Sherlock,London

Clouseau,Paris

The "$" symbol indicates the presence of headers on that line, and the values in subsequent rows map to these headers.

Most CSV parsers will just parse the lines. It's up to you to interpret the first line as a header. Or not. So it's up to you to recognize a second header too. — Andreas
– Andreas, Commented Sep 22, 2015 at 17:09

josliber · Accepted Answer · 2015-12-10 05:20:10Z

1

Not sure about your particular use case, but you can simply read all rows and check when a header row appears.

univocity-parsers allows you to handle this without any trouble.

CsvParserSettings settings = new CsvParserSettings();
CsvParser parser = new CsvParser(settings);
List<String[]> allRows = parser.parseAll(new FileReader(new File("/path/to/your.csv")));
for(String[] row : allRows){
     if(isHeaderRow(row)){ // isHeaderRow() would test whether each element is enclosed within $
          // do stuff to "switch" to a new header row.
     } else {
          // do stuff
     }
}

Disclosure: I am the author of this library. It's open-source and free (Apache V2.0 license).

edited Dec 10, 2015 at 5:20

josliber

44.4k12 gold badges103 silver badges136 bronze badges

answered Sep 25, 2015 at 5:05

Jeronimo Backes

6,2992 gold badges27 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Andriy Slobodyanyk Over a year ago

Got the 1Gb csv file both with unescaped quotes and multi-line values. Much thanks to @jeronimo-backes for his univocity-parsers. Small memory footprint, flexible settings, friendly support.

Yiao SUN · Accepted Answer · 2017-11-20 08:35:42Z

0

You can use JEzCSV for Parsing the fichier csv with anytype dimiliter that you want

answered Nov 20, 2017 at 8:35

Yiao SUN

9981 gold badge10 silver badges27 bronze badges

Collectives™ on Stack Overflow

Parser for CSV with headers on multiple lines using Java

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related