Skip first line using Open CSV reader

Question

Here is the line i am using currently

File booleanTopicFile;
// booleanTopicFile is csv file uploaded from form
CSVReader csvReader = new CSVReader(new InputStreamReader(new FileInputStream(booleanTopicFile), "UTF-8"));

Want to skip the first line of the csv which contains headings. I dont want to use any separator as except the default one comma(,) which is already available in default constructor. In parameterized constructor there is a option to skip no. of lines but how to deal with the 2nd and 3rd param of the constructor.

CSVReader csvReader = new CSVReader(new InputStreamReader(Reader reader, char c, char c1, int index);

-- Thanks

Why don't you just read the first line and do nothing with it? — svz
– svz, Commented Nov 27, 2012 at 8:01
csvReader.readNext(); before the loop, is an alternative solution, but would be optimal if its possible through constructor. — Sangram Anand
– Sangram Anand, Commented Nov 27, 2012 at 8:02
Currently, the answer by @dazito is the correct one. It uses the CSVReaderBuilder and its withSkipLines() method to return a CSVReader with the desired number of lines to skip. This design leverages the library’s intended functionality for this purpose rather than manually invoking readLine() and discarding its output. On that note, @svz, ignoring a method's return value is generally seen as an anti-pattern and can hide potential issues. Using CSVReaderBuilder makes the intent clear. — Lucubrator
– Lucubrator, Commented Apr 14 at 14:58

Chris · Accepted Answer · 2013-02-01 09:01:59Z

35

This constructor of CSVReader class will skip 1st line of the csv while reading the file.

CSVReader reader = new CSVReader(new FileReader(file), ',', '\'', 1);

edited Feb 1, 2013 at 9:01

Chris

7,8248 gold badges54 silver badges103 bronze badges

answered Feb 1, 2013 at 8:45

Abhijeet Doshi

3744 silver badges5 bronze badges

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

5 Comments

Christophe Roussy Over a year ago

+1 Correct answer but don't most CSV files use double quoting ? So it would be new CSVReader(new StringReader(csvText), CSVReader.DEFAULT_SEPARATOR, CSVReader.DEFAULT_QUOTE_CHARACTER, 1); instead.

nyxz Over a year ago

In version 2.3 the DEFAULT_SEPARATOR and DEFAULT_QUOTE_CHARACTER are now in CSVParser class.

Vikas Over a year ago

There is one issue with this. If a csv is having values containing single quote, it will skip that record. e.g Adrian,D'sousa,Agent

wheeleruniverse Over a year ago

Just fyi, but this constructor is deprecated in Version 4.0. Not sure how I can achieve the same functionality without using deprecated methods.

Vishnu Atrai Over a year ago

this is deprecated you can use => CSVReader csvReader = new CSVReaderBuilder(new FileReader(csvFileName)).withSkipLines(1).build()

dazito · Accepted Answer · 2016-11-25 11:35:15Z

31

At least since version 3.8 you can use the CSVReaderBuilder and set it to skip the first line.

Example:

CSVReader reader = new CSVReaderBuilder(inputStreamReader)
                .withFieldAsNull(CSVReaderNullFieldIndicator.EMPTY_SEPARATORS)
                // Skip the header
                .withSkipLines(1)
                .build();

answered Nov 25, 2016 at 11:35

dazito

8,04016 gold badges81 silver badges123 bronze badges

1 Comment

Eduardo Over a year ago

This is the right way to do it, forget the accepted answer.

Community · Accepted Answer · 2017-05-23 12:09:51Z

14

I found this question and response helpful, I'd like to expand on Christophe Roussy's comment. In the latest opencsv (2.3 as of this writing) The actual line of code is:

new CSVReader( new StringReader(csvText), CSVParser.DEFAULT_SEPARATOR,
               CSVParser.DEFAULT_QUOTE_CHARACTER, 1);

Note it uses CSVParser instead of CSVReader.

edited May 23, 2017 at 12:09

CommunityBot

11 silver badge

answered Jan 14, 2014 at 14:32

Sinsanator

3814 silver badges16 bronze badges

2 Comments

Stephane Over a year ago

Very helpful. I was looking for a way to use a null char for the quote parameter, when I saw your answer.

Lucubrator Apr 14 at 14:46

This constructor is deprecated in Version 4.0. Currently, the answer by @dazito is the correct one.

Vishnu Atrai · Accepted Answer · 2019-09-02 11:24:31Z

5

with latest version opencsv version use -

CSVReader csvReader = new CSVReaderBuilder(new FileReader("book.csv")).withSkipLines(1).build()

answered Sep 2, 2019 at 11:24

Vishnu Atrai

2,36822 silver badges24 bronze badges

1 Comment

dazito Over a year ago

That's what I said in my answer from 2016.

Elsa Lin · Accepted Answer · 2021-11-01 13:18:57Z

0

watFileCsvBeans = new CsvToBeanBuilder<ClassType>(isr)
  .withType(ClassType.class)
  .withIgnoreLeadingWhiteSpace(true)
  // CsvToBeanFilter with a custom allowLine implementation
  .withFilter(line -> !line[0].equals("skipme"))
  .build()
  .parse();

It's useful in my case. Instead, "withSkipLines" is not working for me. opencsv version: 5.5.2

answered Nov 1, 2021 at 13:18

Elsa Lin

11

1 Comment

matt1616 Over a year ago

This was helpful. I had the same issue. withSkipLines is inexplicably not working and this 'hack' worked for me. OpenCsv version 5.7.0.

Maroun · Accepted Answer · 2019-10-10 13:12:08Z

-1

You can also use withFilter:

watFileCsvBeans = new CsvToBeanBuilder<ClassType>(isr)
  .withType(ClassType.class)
  .withIgnoreLeadingWhiteSpace(true)
  // CsvToBeanFilter with a custom allowLine implementation
  .withFilter(line -> !line[0].equals("skipme"))
  .build()
  .parse();

answered Oct 10, 2019 at 13:12

Maroun

96.4k30 gold badges195 silver badges249 bronze badges

1 Comment

logbasex Over a year ago

withSkipLine() worked perfectly, but withFilter() notworking.

Collectives™ on Stack Overflow

Skip first line using Open CSV reader

6 Answers 6

5 Comments

1 Comment

2 Comments

1 Comment

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

5 Comments

1 Comment

2 Comments

1 Comment

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related