Thread: Read CSV File

have to implement a static-public method named "csvToList" in the class "Functionality.java". The method gets a string as input parameter and returns a LinkedList<String[]>.

Signature: csvToList(String path) : LinkedList<String[]>

My problem is to implement this : The method reads a CSV file in the path. Each single line is divided into two parts. The two parts are always separated by a comma. The two parts are normalized by removing any spaces at the front and back, and stored in a string array. This two-pair in string[] is added to the list. The list with the two-pairs is to be returned.

The algorithm must meet the following requirements:

The first row should not be read in, because it contains only the column information.
The normalized entries of a line should be in a string array.
The individual elements of the lines should not contain any spaces in the string array.
If an IOException is thrown when reading the file, null should be returned. Use try & catch for this.

My code:

public static String [] csvToList(String path) {
    String fileName = "c:\\test\\csv\\country.csv";
      String splitBy = ",";
            try {
            BufferedReader br = new BufferedReader(new FileReader(country.csv));
            String line;
            String line1=null;
            while ((line = br.readLine()) != null) {
                System.out.println(line);
            }
            br.close();
        } catch (IOException e) {
            e.printStackTrace();
 
        }
        return null;

Do you have any specific java programming questions about your assignment?

Make a list of the steps the program needs to take to solve the problem. Then take the first item in the list and work on the details of what the program needs to do to implement it.
When you need help, post the list and the item in the list that you are having problems with. Post what you think the computer should do for that step and ask any questions about the problems you are having with it.

Can you post a short simple example of what you are trying to do?
Show a few lines of a CSV file and the desired String array contents.

A problem with using an array is the size needs to be determined before it can be declared and used.
How will the program determine the array's size?

What should go into the String array? Can you post an example?

The normalized entries of a line

What does it mean to normalize entries of a line?

The individual elements of the lines should not contain any spaces

Look at the API doc for the String class. It has methods for removing/replacing characters in a String.
The Java SE classes API doc: http://docs.oracle.com/javase/8/docs/api/index.html