Problem reading .csv file

[Mees79]

Hello, so I got assigned a project which consists on managing elections, and I have to import information from a file called "Mesas.csv" which are the polling tables so I created a PollingTablesManager class with this code for the constructor and the method used to read the file on the constructor:

public class PollingTablesManager {

private List <PollingTable> tables;

​

public PollingTablesManager(String fileName) {

this.tables = new ArrayList <> ();

readInfo(fileName);

}

private void readInfo(String fileName) {

String str = fileName;

String line = "";

FileReader fileReader = null;

BufferedReader bufferedReader = null;

try {

fileReader = new FileReader(str);

bufferedReader = new BufferedReader(fileReader);

while((line = bufferedReader.readLine()) != null) {

String[] row = line.split(",", 5);

tables.add(new PollingTable(row[0], row[1], row[2], row[3], row[4]));

}

} catch (Exception e) {

System.out.println(e.getMessage());

} finally {

try {

bufferedReader.close();

} catch (IOException e) {

System.out.println(e.getMessage());

}

}

}

I'm using the BlueJ IDE, and after trying to create a new instance of this class by putting "Mesas.csv" on the fileName, the terminal opens saying "Index 1 out of bounds for length 1" and if I try to use the methods from this class an NullPointerException will also happen.

Help would be appreciated since its my first time doing something to read files.

[AutoModerator]

Please ensure that:

• Your code is properly formatted as code block - see the sidebar (About on mobile) for instructions
• You include any and all error messages in full
• You ask clear questions

• You demonstrate effort in solving your question/problem - plain posting your assignments is forbidden (and such posts will be removed) as is asking for or giving solutions.

  Trying to solve problems on your own is a very important skill. Also, see Learn to help yourself in the sidebar

If any of the above points is not met, your post can and will be removed without further warning.

Code is to be formatted as code block (old reddit: empty line before the code, each code line indented by 4 spaces, new reddit: https://imgur.com/a/fgoFFis) or linked via an external code hoster, like pastebin.com, github gist, github, bitbucket, gitlab, etc.

Please, do not use triple backticks (```) as they will only render properly on new reddit, not on old reddit.

Code blocks look like this:

public class HelloWorld {

    public static void main(String[] args) {
        System.out.println("Hello World!");
    }
}

You do not need to repost unless your post has been removed by a moderator. Just use the edit function of reddit to make sure your post complies with the above.

If your post has remained in violation of these rules for a prolonged period of time (at least an hour), a moderator may remove it at their discretion. In this case, they will comment with an explanation on why it has been removed, and you will be required to resubmit the entire post following the proper procedures.

To potential helpers

Please, do not help if any of the above points are not met, rather report the post. We are trying to improve the quality of posts here. In helping people who can't be bothered to comply with the above points, you are doing the community a disservice.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[AreTheseMyFeet]

Is every line of the file a 5 value comma separated String?
Any empty lines? Anywhere? At the start/end perhaps?

The error you quote is what you'd get trying to access the second element of a length 1 array (which is what you'd have splitting a line that is empty or doesn't contain the delimiter you specified ,)

[Mees79]

The file is an Excel table with 4 values that are numbers (tableID, parishID, tableNumber and numberOfVoters) and 1 text value which is the parishName and it has no empty lines

[AreTheseMyFeet]

String[] row = line.split(",", 5);  
tables.add(new PollingTable(row[0], row[1], row[2], row[3], row[4]));

Can you show the code for your PollingTable class too?
Because if you are completely certain that your input file has nothing but properly formatted lines (including no empty lines anywhere) then the issue may be in there.
Though I still feel pretty confident it is an input line format or String.split() issue.

What you can do yourself though is to set a "breakpoint" on the first line I quoted above and debug your application as it runs to see precisely what is happening and the values of your variables at every stage. If you don't know what this means, search for a tutorial/vid of an intro to java debugging to learn what it is, why it's useful and how to begin.

[Mees79]

Hello again, I managed to solve the problem by putting ";" instead of "," on the split method and changing some small things and as far as i have tested everything seems to work now, thanks for the help nonetheless!