Justin Char

I still don't understand how to get this to work?

I don't understand what you mean. I don't understand how that would work.

I can read a file with bufferedReader. I don't understand how to do the compare with the BufferedReader and hashset?

When I print it out it is eleven and eleven...
I don't even think that is the right way to go about doing it.

I have been working on this and tried the below if stmt.
says there are no matches but I know there are matches.
import java.io.File; import java.io.FileNotFoundException; import java.util.Scanner; public class jkjkjk { public static void main(String[] args) { File oldfile = new File("C:\\NOV022009X.TXT"); File oldfile2 = new File("C:\\EclipseProjects\\ADI914A\\DaveNov292009.txt"); try { Scanner scanner = new Scanner(oldfile); Scanner scanner2 = new Scanner(oldfile2); while (scanner.hasNextLine()) { String line = scanner.nextLine(); String line2 = scanner2.nextLine(); // int a=0; //for (a=0; a<40000; a++)// if (line.substring(0,11).equals(line2.substring(0,3)+ line2.substring(3,9)+line2.substring(10,12))) { //System.out.println(line); System.out.println(line); // scanner.hasNext(oldfile) == scanner2.hasNext(oldfile2); } // getPath("C:\\EclipseProjects\\ADI914A\\DaveNov292009.txt"); // String line2 = scanner2.nextLine(); // if (line2.substring(0,11).equals("00 28890000")) // { // System.out.println(line2); // } } } catch (FileNotFoundException e) { e.printStackTrace(); } } private static void getPath(String string) { // TODO Auto-generated method stub } private static void getPath() { // TODO Auto-generated method stub } private static Object substring(String line2, int i, int j) { // TODO Auto-generated method stub return null; } private static boolean substring(boolean equals) { // TODO Auto-generated method stub return false; } }

By File - Yes, I do mean a line - Sorry

I am trying to read the first 11 characters of the first line from one file and look for matches in the 1st 11 characters of the second file and find all the ones that match and write them out to a file. I know how to write them out to a file.

Just having problems on how I would compare the two files with scanner, or using an array or a for loop. I have no idea on how to do this and have it complete in under 15 minutes.

With scanner I could only get it to allow me to put in a series of numbers and match it to a line on one of the files.

I want to find the files that match in both files.
It will need to grab the first file number Run through 3million records to see if there is a match.
I will sort them by number so it won't have to go through all 3 million everytime.
Both files are not the same size.

Trying to compare two files one has 3 million records the other has 250,000
I want to loop through scanner with scanner2 line by line so if there is a match I can then substring file Number and a couple other fields off the file with 3 million records. Currently I can only put in a file number and find one record.
I don't understand what needs to be done to get oldfile2 to take 1st file number loop through oldfile if there is a match write out data then take 2nd file number and so on.

Thank you in advance for your help.

import java.io.File; import java.io.FileNotFoundException; import java.util.Scanner; public class jkjkjk { public static void main(String[] args) { File oldfile = new File("C:\\NOV022009X.TXT"); File oldfile2 = new File("C:\\EclipseProjects\\ADI914A\\DaveNov292009.txt"); try { Scanner scanner = new Scanner(oldfile); Scanner scanner2 = new Scanner(oldfile2); while (scanner.hasNextLine()) { String line = scanner.nextLine(); if (line.substring(0,11).equals("99 99999900")) { System.out.println(line); } // String line2 = scanner2.nextLine(); // if (line2.substring(0,11).equals("99 99999900")) // { // System.out.println(line2); // } } } catch (FileNotFoundException e) { e.printStackTrace(); } } private static Object substring(String line2, int i, int j) { // TODO Auto-generated method stub return null; } private static boolean substring(boolean equals) { // TODO Auto-generated method stub return false; } }

I got it!!!

I am good....Thank you...Really I am good....(smile)

Dum Dum Dum mistakes...

Thank you for all your help!!

I was wrong it isn't working still

console:

08A EDUCATION PRINCIPAL: 1644382
08A EDUCATION PRINCIPAL: 2033208
08A EDUCATION PRINCIPAL: 2033208

I still can't get it to print out the total 2033208 by itself. It prints all 3 amounts everytime.

This is driving me nuts. Current Code below.

This shouldn't be that difficult. (smile) Maybe I am just not as smart as I thought I was.
import java.awt.Font; import java.io.BufferedReader; import java.io.BufferedWriter; import java.io.FileReader; import java.io.FileWriter; import java.io.IOException; import java.io.FileNotFoundException; import java.text.DecimalFormat; import java.text.NumberFormat; import java.util.Calendar; import java.util.Date; import java.util.GregorianCalendar; public class CashProof2 { public static void main(String[] args) { try { Font f = new Font("Lucida Sans Typewriter", Font.ITALIC, 48); Calendar cal = new GregorianCalendar(); System.out.println("Started : " + cal.getTime()); String SavedTime = cal.getTime().toString(); Date Newdate = new Date(); cal.setTime(Newdate); cal.add(Calendar.DATE, -60); String sp = fillString(' ', 123); // A blank line BufferedReader MAYFILE = new BufferedReader(new FileReader("C:\\CASHPROOFREPORTS2.txt"));// Changed name of file. NumberFormat JK = new DecimalFormat("0000000"); BufferedWriter Counter = new BufferedWriter(new FileWriter("C:\\Count04eJan09zz.txt")); String line; String strOut; long iSUM =0; while ((line = MAYFILE.readLine()) != null) { int jj = 0; //this is for formatting the AR total dollar amt int c = 0; //this is for formatting the count if(line.contains("070") && line.contains("**HV1")) { String j = line.substring(106, 114); //************************************// // iSUM+= substring(106, 114); // iSUM+= Integer.valueOf(j); // System.out.println(iSUM); //*************************************// iSUM+= substring(106, 114); int i = Integer.parseInt(j); //parseInt will probably give better performance than valueOf System.out.printf("Value of \"i\" this time round: %d, ", i); //test long Justin = iSUM += i; System.out.printf("and the total in iSum is now %d.%n", iSUM); //test System.out.print(j); // long Education = Justin; // System.out.print(i); // System.out.println(Education); // strOut = (" Center " + SavedTime); // Counter.write(strOut); // new Font("Serif", Font.PLAIN, 48); // Counter.newLine(); // strOut = (" PROOF"); // Counter.write(strOut); // Counter.newLine(); strOut = ("08A EDUCATION PRINCIPAL: " + sp.substring(1,(11 - c)) + JK.format(iSUM) + sp.substring(1,(31 - jj)) ); Counter.write(strOut); Counter.newLine(); } //end if }//end for Counter.close(); }//end catch catch (IOException e) { e.printStackTrace(); }//end catch } public static String fillString(char fillChar, int count) { // creates a string of 'x' repeating characters char[] chars = new char[count]; while (count>0) chars[--count] = fillChar; return new String(chars); }// end fill string private static long substring(int i, int j) { // TODO Auto-generated method stub return 0; } }//end class

I added this ("long Justin = iSUM += i;") to the last code you sent me and it now does what I needed it to do.
I tried using scanner like you said had problems. I will wait one day and then hopefully you can help me understand the scanner method.

Thank you very much for your assistance you saved me.

The numbers are in exactly the same place everytime. The one I sent you I had to paste so maybe things moved around. I couldn't send as attachment on here because tells me doesn't except txt files.

The problem is there are three numbers associated with iSUM and when It prints I get three results for iSUM
I only want to get one the total which as you can see above I get one of the numbers I am adding and two total amounts. The total Amounts are accurate. I just don't know what to do to get one result and have it be the total amount of 2033208.

When I do System.out.println(j) I get the three amounts I am adding.

When I do a System.out.println(iSUM) I get Three amounts - one amount being the first line I am adding and the following two the total I need. But I need it to print once not twice.

If you can help me with that I put up another post for at least a day (smile)

Took me more than 10 min (smile)

The 2033208 is the number I am looking for (but only that one number) as you can see my output shows three numbers and I don't know how to make it just my total number. I have looked at scanner and couldn't get it to work either.
Output
1644382
2033208
2033208
import java.io.BufferedReader; import java.io.BufferedWriter; import java.io.FileReader; import java.io.FileWriter; import java.io.IOException; import java.io.FileNotFoundException; public class CashProof2 { public static void main(String[] args) { try { BufferedReader MAYFILE = new BufferedReader(new FileReader("C:\\CASHPROOFREPORTS2.txt"));// Changed name of file. BufferedWriter Counter = new BufferedWriter(new FileWriter("C:\\Count04eJan09zz.txt")); String line; String strOut; long iSUM =0; while ((line = MAYFILE.readLine()) != null) { if(line.contains("070") && line.contains("**HV1")) { String j = line.substring(106, 114); //************************************// // iSUM+= substring(106, 114); iSUM+= Integer.valueOf(j); System.out.println(iSUM); //*************************************// strOut = "Totals" + " " + iSUM; Counter.write(strOut); Counter.newLine(); } //end if }//end for Counter.close(); }//end catch catch (IOException e) { e.printStackTrace(); }//end catch }// end fill string private static long substring(int i, int j) { // TODO Auto-generated method stub return 0; } }//end class

I can't add an attachment says cannot send txt files..Just copy and put in text file. Delete (//)commented lines just notes so you know what numbers I am grabbing.

070 32**HV1

0819200R0000000000000000000000000000000000000000000000000000000000000000043016443820000000000000000000000000000000000000000


//1644382 this is the number in above string looking for to add with next two
0701201**HV1

0819200R0000000000000601495945000000000000130115724100000000000000749000018003888260203320800035923000206210000000000000000


//388826 2 nd number I want to add in above string 8 char field for each number
0701801**HV1

081920090000000000000000000000000000000000000000000000900220702000000000000000000000000000000000000000000000000000000000000

//00000000 this field is 0 zeros but could have 10 won't always be three numbers I am adding .



import java.awt.List; import java.io.BufferedReader; import java.io.BufferedWriter; import java.io.FileReader; import java.io.FileWriter; import java.io.IOException; import java.text.DecimalFormat; import java.text.NumberFormat; import java.util.Arrays; import java.util.Collections; import java.util.Scanner; import java.util.logging.ConsoleHandler; import java.io.FileNotFoundException; public class StartStart2 { public static void main(String[] args) { //} try { BufferedReader MAYFILE = null; try { BufferedReader MAYFILE1 = new BufferedReader(new FileReader("C:\\CASHPROOFREPORTS2.txt")); //int ictCASH1 = 0; String strOut; NumberFormat formatterJ = new DecimalFormat("00000000"); BufferedWriter Counter1 = new BufferedWriter(new FileWriter("C:\\Count04eJan09zz.txt")); //BufferedReader MAYFILE = new BufferedReader(new FileReader("C:\\CASHPROOFREPORTS.txt")); String line; BufferedWriter Counter = new BufferedWriter(new FileWriter("C:\\Count04eJan09zz.txt")); while ((line = MAYFILE1.readLine()) != null) { int ict = 0; ict++; if(line.contains("070") && line.contains("**HV1")) { System.out.println(line); String justin = line.substring(106,114); justin.indexOf(justin); // System.out.println(justin); String aString = justin; int aInt = Integer.parseInt(aString); formatterJ.format(aInt); int Dave = aInt; //************************************// int iSUM = 0; iSUM+= Integer.valueOf(aInt); System.out.println(iSUM); //*************************************// String aString1 = justin; double aDouble = Double.parseDouble(aString1); // int a = Integer.parseInt(args[0]); // int b = Integer.parseInt(args[1]); // int c = Integer.parseInt(args[2]); // int sum = a + b + c; // System.out.println("Sum: " + sum); // Scanner in = new Scanner(System.in); //double aInt1 = 0; // double n = aInt.nextDouble(); // aInt = aInt + n; //System.out.println("The total is " + aInt); // System.out.println(aInt * 2); // System.out.println(aInt); //System.out.println(justin+=(aString)); //System.out.println(aInt); //int[] myArray = {1,2,3}; //System.out.println(myArray.length); // double amount = aDouble; // System.out.println(justin+=(aDouble)); // System.out.println(aDouble); strOut = aString + aInt; Counter.write(strOut); Counter.newLine(); } }//end for Counter.close(); }//end inner try finally { if (MAYFILE != null) { MAYFILE.close(); }//end if }//end finally }//end outer try // As before but an additional catch catch (FileNotFoundException fnf) { fnf.printStackTrace(); }//end catch catch (IOException e) { e.printStackTrace(); } } private static int getDouble(int int1) { // TODO Auto-generated method stub return 0; } private static void While() { // TODO Auto-generated method stub } private static void sum(String justin) { // TODO Auto-generated method stub } public static String fillString(char fillChar, int count){ // creates a string of 'x' repeating characters char[] chars = new char[count]; while (count>0) chars[--count] = fillChar; return new String(chars); // } }//end catch }//end main

I put this in my while stmt. Just prints the 3 numbers that are in aInt variable..

int iSUM = 0; iSUM+= Integer.valueOf(aInt); System.out.println(iSUM);

I did multiply * 2 and it multiplied the first number but not the other two.