Using Apache Commons CSV to read file starting from the second line

Question

I have this CSV file that I want to read:

ID;Name;Age
GEORGE;GEORGE;19
JOHN;JOHNNY;45
MARCO;MARCO POLO;32

I also have to read it using this command:

for (CSVRecord rec : CSVFormat.DEFAULT.withDelimiter(';').parse(in)) {
    //some code
}

I don't want to read the first line, because it's just the description of what contain the fields

I also tried to find the resolution of this in stackoverflow and other sites, but I didn't find how to do it.

EDIT 1: I imported CSVRecord and CSVFormat from org.apache.commons.csv.CSVFormat and org.apache.commons.csv.CSVRecord

EDIT 2: My post is not a duplicate because I'm asking about a library, just as @slim commented

What is that `CSVRecord`, and `CSVFormat`? You have to show us more of what you have. — E_net4, Sep 27 '16 at 15:46
Possible duplicate of [Skip first line while reading CSV file in Java](http://stackoverflow.com/questions/18306270/skip-first-line-while-reading-csv-file-in-java) — YMomb, Sep 27 '16 at 15:51
@YMomb - not really a dupe. This post is asking about a library. The other is rolling their own parser. — slim, Sep 27 '16 at 16:11

slim · Accepted Answer · 2016-09-27T16:12:11.517

4

See the "Working with headers" section of the user guide.

Specifically, you can configure the parser to know that the first line is a header, using CSVFormat.withFirstRowAsHeader()

edited Sep 27 '16 at 16:12

answered Sep 27 '16 at 15:52

slim

score 1 · Answer 2 · edited May 23 '17 at 12:06

1

There are many stackoverflow resources for this question. Skip first line while reading CSV file in Java seems like the best resource for your answer.

edited May 23 '17 at 12:06

Community

answered Sep 27 '16 at 15:48

woodhead92

Also, if you are interested in only using CSVRecord, the [solution](https://examples.javacodegeeks.com/core-java/apache/commons/csv-commons/writeread-csv-files-with-apache-commons-csv-example/) provided for 'Read from CSV File' would do the trick! – woodhead92 Sep 27 '16 at 15:51

2 Answers2