StringTokenizer, substring, for loop, while loop, filereader, filewriter

[brando brandido]

hello,

i have some text in notepad that looks like this

Day 1, Product 1, 5000
Day 1, Product 2, 5859.99
Day 1, Product 3, 6001.75
Day 2, Product 1, 5555
Day 2, Product 2, 7750.99
Day 2, Product 3, 6000
Day 3, Product 1, 5877.85
Day 3, Product 2, 5559.30
Day 3, Product 3, 6578.98

i am ask to create a program to call the notepad and make the output looks like this

       Product 1    Product 2    Product 3

Day 1    5000     5859.99    6001.75
Day 2    5555     7750.99    6000.50
Day 3    5877    5559.30    6578.98

i posted this in a different thread but seems the suggestion are too advance for me? i just want it simple and easy to explain.

i am a bit confuse, so i hope you guys can advice me

so so far what i've done is this;

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

    public class SalesSummary2
    {
        public static void main (String [] args)throws IOException
        {
            FileReader fr = new FileReader("notepad.txt");


            BufferedReader notepad = new BufferedReader(fr);
            String data = notepad.readLine();

            for(int i = 1; i <= 3; i++){
                while(i<=3){

                	String sub1 = data.substring(7, 14);
                    String p1 = sub1;
                    System.out.print("\t" + p1 + " " + i);
                    i++;
                }

                	String sub2 = data.substring(0, 5);
                	String p2 = sub2;
                	System.out.print("\n\n" + p2  );


               for (int j = 1; j<=3; j++) {

                    data = notepad.readLine();
                	String sub3 = data.substring(17);
                    StringTokenizer st = new StringTokenizer(sub3);
                    String p3 =  st.nextToken();
                    System.out.print(" " +p3);
                    j++;

               }

            }

            fr.close();
        }




    }

the problem with the above code is that, the amount "5000" won't appear,

the output will look like this;


       Product 1    Product 2    Product 3

Day 1     5859.99    6001.75

Question: what should i do in order that the amount "5000" will be included in the second FOR loop?


so in my own way, for me to get the "5000" amount i modified the code to like this, and that's the time i got all the amount on day 1.

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

    public class SalesSummary2
    {
        public static void main (String [] args)throws IOException
        {
            FileReader fr = new FileReader("notepad.txt");


            BufferedReader notepad = new BufferedReader(fr);
            String data = notepad.readLine();

            for(int i = 1; i <= 3; i++){
                while(i<=3){

                	String sub1 = data.substring(7, 14);
                    String p1 = sub1;
                    System.out.print("\t" + p1 + " " + i);
                    i++;
                }

                	String sub2 = data.substring(0, 5);
                	String p2 = sub2;
                	System.out.print("\n\n" + p2  );

                	String sub3 = data.substring(17);
                	String p3 = sub3;
                	System.out.print(" " + p3);

               for (int j = 1; j<=3; j++) {

                    data = notepad.readLine();
                	String sub4 = data.substring(17);
                    StringTokenizer st = new StringTokenizer(sub4, "\n ");
                    String p4 =  st.nextToken();
                    System.out.print(" " +p4);
                    j++;

               }

            }

            fr.close();
        }
    }

[Joanne Neal]

There's so much wrong with that code that the best advice anyone can give you is to dump it and start again.

Campbell's usual advice is to write down the steps that you will need to do on a piece of paper. Then refine each step into smaller steps. Keep doing this until all the steps consist of a few one or two syllable words. Don't write any code until you've done this.
Then switch to Fred's usual advice. For each step you have defined, write a few lines, compile them and test them and only when they do exactly what you want should you move on to the next step.

If you do things like this, then when you do come across a problem, you can narrow it down to exactly where in the code it is and then you will only need to post that bit of code on these forums. The less code you need to post to explain the problem, the easier it is for other people to scan the code and spot what the problem is.

[Campbell Ritchie]

I think you ought to continue on the original thread. I shall close this one, and copy your post onto the old thread.

[Campbell Ritchie]

Have you been taking lessons from Rob, Joanne?
There I was, closing threads so I could write about pencils elsewhere and you manage to slip in a post before me!

If you click the link in that previous line, you get to the location where I copied that post.