How to select specific line from CSV file using unique value

Question

I have a few line CSV file which contains these values:

2, Joe, BMW
6, Mark, Audio
7, Jeff, Fiat
9, Mike, Toyota

Now I know how to select specific line using OpenCSV ie. line 1, 2 or 3 etc. But I don't know how to select line which has first value 6 for example. Any suggestions?

Thanks

Answer 1

You could:

Reader reader = new FileReader("data.csv");
List<String[]> rows = new CSVReader(reader).readAll();

for(String[] column: rows) {
if (column[1].equals("6")){
    System.out.println("Found row No. is " + rows.indexOf(column));
}
}