How to display a list of the specific data?

[boiishuvo]

the data file contains:

1908,Souths,Easts,Souths,Cumberland,Y,14,12,4000
1909,Souths,Balmain,Souths,Wests,N
1910,Newtown,Souths,Newtown,Wests,Y,4,4,14000
1911,Easts,Glebe,Glebe,Balmain,Y,11,8,20000

Each line represents a season of premiership and has the following format: year, premiers, runners up, minor premiers, wooden spooners, Grand Final held, winning score, losing score, crowd

What I need is to display a list of Grand Final held as 'Y'. In other words, how do I display a list of 'Y' which is after the 5th comma?

import java.io.*;
import java.util.ArrayList;

public class GrandFinal {

    private static BufferedReader br = null;
    private static ArrayList<String> al = new ArrayList<String>();
    private static String line = "";

    public static void storeArray() {       
        try {            
            br = new BufferedReader(new FileReader("NRLdata.txt"));
            while ((line = br.readLine()) != null)
                al.add(line);
        }
        catch (Exception e) {
            System.out.println("Unable to find file.");
        }

        for (int i = 0; i < al.size(); i++) {
            // this line.
            }
        }
    }
}

[stultuske]

you can use String's split method with comma as separator, and then check if the 6th element is Y.
if so, print, if not, don't.

[boiishuvo]

for (int i = 0; i < al.size(); i++) {
            String[] parts = al.get(i).split(",");
            System.out.println(parts[i]);
        }

How's that? It doesn't display properly.

[stultuske]

why are you not using your 'line' variable?

anyway, "doesn't display properly" doesn't really tell us much.
what I suggested was: check the element of parts with index 5. if that equals "Y", then print al.get(i), not parts with index i.

[boiishuvo]

I am apologise for the inconvenience. Umm what I have wrote is

for (int i = 0; i < al.size(); i++) {
            String[] parts = al.get(i).split(",");
            if(parts[i].indexOf(5).equals("Y"))
                System.out.println(al.get(i));
        }

But the 3rd line has an error. Not sure what's wrong with it.

[boiishuvo]

I made a new code over again without using Linked List since I wasn't taught to use Linked List, instead of the regular array. Here's the code:

import java.io.*;
import java.util.Scanner;

public class GrandFinal {
    public static Scanner file;
    public static String[] array = new String[1000];

    public static void main(String[] args) throws FileNotFoundException {
        File myfile = new File("NRLdata.txt");
        file = new Scanner (myfile);
        Scanner s = file.useDelimiter(",");
        int i = 0;
        while (s.hasNext()) {
            i++;
            array[i] = s.next();
        }
        /*
        for(int j=0; j<array.length; j++) {
        if(array[j] == null)
            ;
        else
            System.out.print(array[j] + " ");
        }
        */

        for(int j=0; j<array.length; j++) {
            if(array[j] == null)
                ;
            else if(array[j].contains("Y"))
                System.out.println(array[j] + " ");
        }
    }
}

When I ran the program it just displayed "Y Y Y Y Y Y Y..." which is not what I expected. What I need is to display all seasons with "Y".

[stultuske]

for (int i = 0; i < al.size(); i++) {
            String[] parts = al.get(i).split(",");
            if(parts[i].indexOf(5).equals("Y"))
                System.out.println(al.get(i));
        }

here you were on the right track, but what exactly do you need that 'indexOf' for? just look in the api for String, and you'll see that 's not what you want at all.

at that part, you have an array of Strings of (minimal) 6 elements.
what you need to do is check whether or not the 6th element (index = 5) equals "Y", so just replace the above code with:

for (int i = 0; i < al.size(); i++) {
            String[] parts = al.get(i).split(",");
            if(parts[5].equals("Y"))
                System.out.println(al.get(i));
        }

and try again.