Array Out of Bounds error while Reading 2 Column Csv File using OpenCsv

Question

I am reading a 2 column CSV using opencsv library and I want to put those 2 columns as key-value pairs in a map. However, I am getting Array Index out of bounds exception whenever there is an empty line in CSV. Is there any way I can avoid that? This is my code:

    Map<String, String> map = new HashMap<>();
    CSVReader csvReader;
    try (FileReader filereader = new FileReader(path)) {
        csvReader = new CSVReader(filereader);
        String[] nextRecord;
        while ((nextRecord = csvReader.readNext()) != null) {
            if (nextRecord[0] != null && nextRecord[1] != null) {
                map.put(nextRecord[0], nextRecord[1]);
            }
        }

    } catch (Exception e) {
        System.out.print(e);
    }

all entries in your file does not have comma. Please paste the contents of your file If its ok. Check the length of the nextRecord array before you access nextRecord[index] — Pramod
– Pramod, Commented Jul 9, 2021 at 6:45
try to use readNextSilently and check that nextRecord != null && nextRecord.length > 1 — Alexander Alexandrov
– Alexander Alexandrov, Commented Jul 9, 2021 at 6:48

flyingfox · Accepted Answer · 2021-07-09 06:55:36Z

2

array of nextRecord might be empty, so you need to check the length before indexing it

change

if(nextRecord[0]!=null && nextRecord[1]!=null){
     map.put(nextRecrod[0],nextRecord[1]);
}

to

if(nextRecord.length ==2 && nextRecord[0]!=null && nextRecord[1]!=null){
     map.put(nextRecrod[0],nextRecord[1]);
}

answered Jul 9, 2021 at 6:55

flyingfox

13.5k4 gold badges30 silver badges43 bronze badges

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

Collectives™ on Stack Overflow

Array Out of Bounds error while Reading 2 Column Csv File using OpenCsv

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related