how to read a specific row from csv file using CsvReader in java

Question

I am using CsvReader library and want to read a specific row from a csv file in java. Sample csv :

**Name**,     **Address**,        **Email-Id**
student,    studentaddress,     [email protected] 
student2,   student2address,    [email protected] 
employee,   employeeaddres1,    [email protected]

I want to read the row where name is 'student2'. Could you please provide a solution?

Thanks in advance.

Denys Séguret · Accepted Answer · 2012-08-28 11:58:40Z

5

As rows have different sizes in bytes, and as the CSV format doesn't contain an index, you can't have a random access directly to one row.

So you must read all precedent rows and simply skip them until you're at the desired one.

answered Aug 28, 2012 at 11:58

Denys Séguret

384k90 gold badges813 silver badges780 bronze badges

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

Comments

Abin Manathoor Devasia · Accepted Answer · 2012-11-19 01:59:12Z

2

I have some experience with this type of operation , just try this API http://opencsv.sourceforge.net/

we have an option to skip the first n records

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

this shows it will skip the first 2 records. look through it

Other API's

edited Nov 19, 2012 at 1:59

answered Nov 16, 2012 at 9:52

Abin Manathoor Devasia

1,9572 gold badges21 silver badges47 bronze badges

1 Comment

James Bassett Over a year ago

opencsv isn't an Apache project - you're probably confusing it with commons csv

Collectives™ on Stack Overflow

how to read a specific row from csv file using CsvReader in java

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related