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
– E_net4, Commented Sep 27, 2016 at 15:46
Possible duplicate of Skip first line while reading CSV file in Java — YMomb
– YMomb, Commented Sep 27, 2016 at 15:51

slim · Accepted Answer · 2016-09-27 16:12:11Z

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()

answered Sep 27, 2016 at 15:52

slim

41.5k14 gold badges101 silver badges131 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 12:06:43Z

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.

CommunityBot

11 silver badge

answered Sep 27, 2016 at 15:48

woodhead92

1271 silver badge14 bronze badges

Also, if you are interested in only using CSVRecord, the solution provided for 'Read from CSV File' would do the trick!