How to parse the CSV(Comma separation values)file and validate the file using java

[padmajap13]

Hi all.
This is urgent issue. pls help me. How to parse the CSV file and validate the file using Java

[Eranga]

Are looking to parse it through JDBC?

[padmajap13]

No,Using Java.io package and validations also need

[Eranga]

Ok, simply read the file as a normal text file. Got it?

[danielstoner]

Read the file line by line (readLine()) and parse each line with StringTokenizer for commas(,)

[Eranga]

Yep, that's what I try to explain him. But no feedback there. He just looking a code. I don't like to just give a code. Why they don't try something. ;(

[padmajap13]

Thanks for ur support.pls send the code if u have any possible,pls share the code.I was tried whole day.but i didn`t get any proper output.

[Eranga]

OK try this, a part of it. Read a file and get each line of it. I give a part of it, because best thing is try something yourself and ask here if you stuck. Anyway,

Code:

            FileReader myFile = new FileReader(path_to_CSV_file);
            BufferedReader InputFile = new BufferedReader(myFile);
            // Read the first line
            String currentRecord = InputFile.readLine();
            while(currentRecord != null)
            {
                // Do the record validation here
                
                
                // Important: get the next record.
                currentRecord = InputFile.readLine();
            }

In this way you can read each line of the file. Then think that how to separate data depend on the comma( , ) there are lots of way to do it.