opencsv CSV Reader - Read from specific row onwards.

Question

I've been searching this everywhere, I'm probably just being thick but is there a way to read a csv file from a particular row onwards? I have a csv file but want to read the data from the 14th row onwards. Below is my csv reader.

  CSVReader reader=new CSVReader(new FileReader(filename1));
  String [] value ;

  while((value=reader.readNext())!=null){

The data inside the csv is something like this

    1   djennings93
    2   27/02/2014
    3   13:31
    ...
    14  26/02/14 14:25:00, www.google.co.uk, 50, Google

I'd like to ignore the data from lines 1-13

Boris · Accepted Answer · 2014-02-27 13:56:05Z

4

You can skip the first 13 lines by doing:

CSVReader reader = new CSVReader(new FileReader("yourfile.csv"), '\t', '\'', 13);

Have a look here. (question Can I use my own separators and quote characters?)

This will result in reading the data from the 14th line onward.

edited Feb 27, 2014 at 13:56

answered Feb 27, 2014 at 13:45

Boris

24.7k16 gold badges54 silver badges75 bronze badges

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

3 Comments

djennings93 Over a year ago

cheers mate! It's amazing what a bit of reading can actually do! my bad.

User3 Over a year ago

What about reading to a specific line. Also as soon as I define CSVReader reader is the whole file read? Or the file read happens when I iterate over reader?

Boris Over a year ago

@User3 check section "How do I read and parse a CSV file?" on opencsv.sourceforge.net

Kirill Feoktistov · Accepted Answer · 2018-05-11 15:46:07Z

3

Boris's answer still works but deprecated. It is recommended to use builder class:

CSVReader reader = new CSVReaderBuilder(new FileReader("yourfile.csv"))
        .withSkipLines(13)
        .withCSVParser(new CSVParserBuilder().withSeparator('\t').withEscapeChar('\'').build())
        .build();

answered May 11, 2018 at 15:46

Kirill Feoktistov

1,44825 silver badges29 bronze badges

Collectives™ on Stack Overflow

opencsv CSV Reader - Read from specific row onwards.

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related