File Input in Java

Hint:

• java.util.Scanner

Tutorial:

• The Java Tutorials - Basic I/O - Scanning

Extract of relevance from the tutorial:

To use a different token separator, invoke useDelimiter(), specifying a regular expression. For example, suppose you wanted the token separator to be a comma, optionally followed by white space. You would invoke,

s.useDelimiter(",\\s*");

A scatch:

public static void main(String[] args) throws IOException {
    int[][] numbers = new int[7][4];
    String[] names = new String[7];
    BufferedReader reader = new BufferedReader(new FileReader("datafile"));
    String line;
    int row = 0;
    while ((line = reader.readLine()) != null) {
        String[] cells = line.split(",");
        names[row] = cells[0].trim();
        for (int i = 1; i < cells.length; i++) {
            numbers[row][i - 1] = Integer.parseInt(cells[i].trim());
        }
        row++;
    }
    for (int i = 0; i < names.length; i++) {
        System.out.printf("%s, %.2f%n", names[i], avg(numbers[i]));
    }
    // Do the other average calculation
}
private static double avg(int[] numbers) {
    int sum = 0;
    for (int i = 0; i < numbers.length; i++) {
        sum += numbers[i];
    }
    return sum / numbers.length;
}

Hint:

• BufferedReader.readLine()
• StringTokenizer

File file = new File("C:\\data.txt");
FileInputStream fis = null;
BufferedInputStream bis = null;
DataInputStream dis = null;

try {
  fis = new FileInputStream(file);

  // Here BufferedInputStream is added for fast reading.
  bis = new BufferedInputStream(fis);
  dis = new DataInputStream(bis);

  // dis.available() returns 0 if the file does not have more lines.
  while (dis.available() != 0) {

    /* Read the content from file */
    /* Read a line and check if first element before first comma is a string */
    /* Read four numbers separated by comma after first comma in an arraylist */
    /* Loop around array list to get the average of numbers */
    /* Store the first number from this record in another vector */

    System.out.println(dis.readLine());
  }

  // dispose all the resources after using them.
  fis.close();
  bis.close();
  dis.close();

} catch (FileNotFoundException e) {
  e.printStackTrace();
} catch (IOException e) {
  e.printStackTrace();
}

I'd personally recommend looking at the split method for strings (so you could break up a line into an array of strings) Or stringTokenizer as Brian suggested.

The rest is just calculations and having an array to store it in.

There are some things to consider:

The files on your disk are stored as a sequence of bytes, but when processing text, you need sequences of characters. Therefore, when loading the file, you need to convert the bytes to characters. This can be simply done using these three types:

FileInputStream fis = new FileInputStream("data.txt");
Reader rd = new InputStreamReader(fis, Charset.forName("UTF-8"));
BufferedReader brd = new BufferedReader(rd);

The buffered reader provides a method readLine that is handy for reading input line by line.

Then you would process one line of input at a time. You split the line at all points that consist of some whitespace, a comma, and some whitespace. The regular expression for that is "\\s*,\\s*".

Now you have an array of fields. The first field is the name, which you can use as is. The other fields need to be converted to integer numbers, which can be done with Integer.valueOf(String).

When you have read all lines, you should close the file.