[SOLVED] How to Extract Data From this text file?

OK! I think i've cracked it.. This is now totally generic and if you come back to me and tell me this doesn't work, I give up!!!

Code:

---

import java.io.BufferedReader;
import java.io.FileInputStream;
import java.io.InputStreamReader;

public class csv {

        public static void main(String[] args) throws Exception {
               
                // File path & name
                String filepath = "csv.txt";
               
                // Read in file to determine how many lines it has
                FileInputStream in = new FileInputStream(filepath);
                BufferedReader br = new BufferedReader(new InputStreamReader(in));
                String strLine;
                int counter = 0;
               
                while ((strLine = br.readLine()) != null)
                {
                        counter++;
                }
                       
                in.close();
               
                // Read in file
                FileInputStream in2 = new FileInputStream(filepath);
                BufferedReader br2 = new BufferedReader(new InputStreamReader(in2));
                String strLine2;
               
                // Declare array
                String[] myarray;
                myarray = new String[counter];
                       
                        // Add each line to the array
                        for (int i = 0; i < myarray.length; i++){
                                myarray[i] = br2.readLine();
                        }
               
                in2.close();
               
                // Loop through array looking for the correct text, format & print
                for (int c = 0; c < myarray.length; c++){
                       
                        if(myarray[c].contains("INVOICE NO") | myarray[c].contains("invoice No") ){
                                                               
                                String[] split = myarray[c+1].split(" ");
                               
                                String invoicePt1 = "";
                                String invoicePt2 = "";
                                String dated = "";
                               
                                for (int i = 0; i < split.length; i++){
                                        if (split[i].length() == 4 &! split[i].contains("-")){
                                                invoicePt1 = split[i].replace("\"", "");
                                                }
                                        if (split[i].length() > 1 &! split[i].contains("-")){
                                                invoicePt2 = split[i].replace("\"", "");
                                                }
                                        else
                                        {
                                                dated = split[i].replace("\"", "").trim();
                                        }
                                }
                                                                                       
                                System.out.println("INVOICE NO: " + invoicePt1 + " " + invoicePt2);
                                System.out.println("Dated: " + dated);
                        }
                       
                        if(myarray[c].contains("Buyer's Order")){
                               
                                String[] split = myarray[c+1].split(" ");
                                String buyersDate = "";                               
                                String buyersOrder = "";
                               
                                for (int i = 0; i < split.length; i++){
                                        if (split[i].length() > 1 &! split[i].contains("-")){
                                                buyersOrder = split[i].replace("\"", "");
                                        }
                                        if (split[i].length() > 1 & split[i].contains("-")){
                                                buyersDate = split[i].replace("\"", "");
                                        }
                                }
                                                               
                                System.out.println("Buyer's Order No: " + buyersOrder );
                                System.out.println("Dated: " + buyersDate.trim());
                        }
                }
        }
}

---

Or:

Code:

---

import java.io.BufferedReader;
import java.io.FileInputStream;
import java.io.InputStreamReader;

public class csv {

        public static void main(String[] args) throws Exception {
               
                // File path & name
                String filepath = "csv.txt";
               
                // Read in file to determine how many lines it has
                FileInputStream in = new FileInputStream(filepath);
                BufferedReader br = new BufferedReader(new InputStreamReader(in));
                String strLine;
                int counter = 0;
               
                while ((strLine = br.readLine()) != null)
                {
                        counter++;
                }
                       
                in.close();
               
                // Read in file
                FileInputStream in2 = new FileInputStream(filepath);
                BufferedReader br2 = new BufferedReader(new InputStreamReader(in2));
                String strLine2;
               
                // Declare array
                String[] myarray;
                myarray = new String[counter];
                       
                        // Add each line to the array
                        for (int i = 0; i < myarray.length; i++){
                                myarray[i] = br2.readLine();
                        }
               
                in2.close();
               
                // Loop through array looking for the correct text, format & print
                for (int c = 0; c < myarray.length; c++){
                       
                        if(myarray[c].contains("INVOICE NO") | myarray[c].contains("invoice No") ){
                                                               
                                String[] split = myarray[c+1].split(" ");
                               
                                String invoicePt1 = "";
                                String invoicePt2 = "";
                                String dated = "";
                               
                                for (int i = 0; i < split.length; i++){
                                        if (split[i].contains("Jan") &! split[i].contains("-")){
                                                invoicePt1 = split[i].replace("\"", "");
                                        }
                                        if (split[i].contains("Feb") &! split[i].contains("-")){
                                                invoicePt1 = split[i].replace("\"", "");
                                        }
                                        if (split[i].contains("Mar") &! split[i].contains("-")){
                                                invoicePt1 = split[i].replace("\"", "");
                                        }
                                        if (split[i].contains("Apr") &! split[i].contains("-")){
                                                invoicePt1 = split[i].replace("\"", "");
                                        }
                                        if (split[i].contains("May") &! split[i].contains("-")){
                                                invoicePt1 = split[i].replace("\"", "");
                                        }
                                        if (split[i].contains("Jun") &! split[i].contains("-")){
                                                invoicePt1 = split[i].replace("\"", "");
                                        }
                                        if (split[i].contains("Jul") &! split[i].contains("-")){
                                                invoicePt1 = split[i].replace("\"", "");
                                        }
                                        if (split[i].contains("Aug") &! split[i].contains("-")){
                                                invoicePt1 = split[i].replace("\"", "");
                                        }
                                        if (split[i].contains("Sep") &! split[i].contains("-")){
                                                invoicePt1 = split[i].replace("\"", "");
                                        }
                                        if (split[i].contains("Oct") &! split[i].contains("-")){
                                                invoicePt1 = split[i].replace("\"", "");
                                        }
                                        if (split[i].contains("Nov") &! split[i].contains("-")){
                                                invoicePt1 = split[i].replace("\"", "");
                                        }
                                        if (split[i].contains("Dec") &! split[i].contains("-")){
                                                invoicePt1 = split[i].replace("\"", "");
                                        }
                                        if (split[i].length() > 1 &! split[i].contains("-")){
                                                invoicePt2 = split[i].replace("\"", "");
                                                }
                                        else
                                        {
                                                dated = split[i].replace("\"", "").trim();
                                        }
                                }
                                                                                       
                                System.out.println("INVOICE NO: " + invoicePt1 + " " + invoicePt2);
                                System.out.println("Dated: " + dated);
                        }
                       
                        if(myarray[c].contains("Buyer's Order")){
                               
                                String[] split = myarray[c+1].split(" ");
                                String buyersDate = "";                               
                                String buyersOrder = "";
                               
                                for (int i = 0; i < split.length; i++){
                                        if (split[i].length() > 1 &! split[i].contains("-")){
                                                buyersOrder = split[i].replace("\"", "");
                                        }
                                        if (split[i].length() > 1 & split[i].contains("-")){
                                                buyersDate = split[i].replace("\"", "");
                                        }
                                }
                                                               
                                System.out.println("Buyer's Order No: " + buyersOrder );
                                System.out.println("Dated: " + buyersDate.trim());
                        }
                }
        }
}

---

Based on the csv file you attached above. This is the output:

Code:

---

INVOICE NO: Feb 08/Pur/21
Dated: 20-Feb-2008
Buyer's Order No: EKA78JN080662
Dated: 20-Mar-2008

---

:D

We cannot predict that because the document is given by the OCR Engine.If the scanned image resolution varies then the data may jumbles...We have givencondition to client to scan with 300dpi when scanning.After Scanning the image will be given to OCR Engine for OCRing.The Output format may be .txt or .csv or any type which we can feel better to retrieve data from that.

I am trying hard with regular Expressions...Hope i ll get...

Thanks for your time and Help...If you want u can try..

thanks
jazz

Try the above code!!!!! Tell me what happens....

Hurrrrrrrrrrrrrrreeeeeeeeeeeeeeeeeyyyyyyyyyyyyyyyy yyyyyyyy

U R SIMPLY SUPERB:cool:

Its Working Maaaan...Really Surprised....

I will try with some other examples and let u Know if i get any...:-)

Thanks for ur valuable time...may i know Your Details...

Quote:

---

U R SIMPLY SUPERB

---

Thanks! Ill never get tired of hearing that! LOL

I tested it with several versions of the csv file and it seems to be working 100%.

That was quite tricky to work out actually!

Please +Rep me ;) :D

Quote:

---

may i know Your Details...

---

What do you mean?

Ahhh...UR Awesome...

Here i want to put some more pressure on u...shall i send you other csv formats which i am trying with .

Your Details Means..What is your actual Name and Your From?soon..:D

Yeah you can do if you want although I can't spend much more time working on this and doing your job for you :p lol..

How much Java do you know because you should easily be able to edit this to suit your needs.

My names Don and im from England :)

Hope this is my last request ....

I tried with .txt format too..its working fine for me...


Here i am attaching my files..can u Have a look ...please..Never Mind..This is the Last Phase Where i stucked Up..

In these files also i ned the same fileds to extract..


I will be awaiting for your response...sorry to disturb You:-)

Which format are you going to be using? The .txt or .csv? The csv file will be easier for me to modify this code for!!

The 'kalatoaster' file is confusing me:

"Invoice No. !Dated"
"Kala Genset Pvt.Ltd."
"392/1, Mahalunge Ingale, Feb 08/Pur118 12-Feb-2008"

Which part of the information do you want to return for Invoice no?

You can make this program work for 'berger.csv' by doing a slight edit.

Locate this piece of code near the bottom:

Code:

---

        for (int i = 0; i < split.length; i++){
                if (split[i].length() > 1 &! split[i].contains("-")){
                        buyersOrder = split[i].replace("\"", "");
                }
                if (split[i].length() > 1 & split[i].contains("-")){
                        buyersDate = split[i].replace("\"", "");
                }
        }

---

And replace with this:

Code:

---

        for (int i = 0; i < split.length; i++){
                if (split[i].length() > 1 &! split[i].contains("-")){
                        buyersOrder = split[i].replace("\"", "");
                }
                if (split[i].length() > 1 & split[i].contains("-")){
                        buyersDate = split[i].replace("\"", "");
                }
                else {
                        buyersDate = myarray[c+2].replace("\"", "");
                }
        }

---

Thanks DON...UR THE REAL DON..can i have your personal mail id???sothat i will be in touch with you..You are very inspiring to me..thanks once again

Hey Jazz2k8.

If you ever want to contact me then your welcome to PM me here.

If you ever want Java help though its always best to posts a thread in the forums because you'll have the benafit of all our members help. I'm not normally around to dedicate as much time to a problem as I have here!

If you feel your questions have been answered. Please mark this thread as solved :)

OK DON..its nice to hear from you..i ll always in touch with you...

Can i have your help in "How to Run an .exe using java" thread???:-)