reading csv file

[imran quazi]

Hi Ranchers,

I want to read a csv file and separate out and store in String each comma separated values. I am stuck at reading a single line at a time. Can anybody please show me a piece of code to do these?

Thanks

[Ricky Martaputra]

Use FileReader, BufferedReader and StringTokenizer

FileReader fReader = new FileReader( filename );
BufferedReader bReader = new BufferedReader( fReader ); // to read per line
//loop, to read per line
//assume there was an initialization of variable line
while( ( line = bReader.readLine() ) != null )
{
//and the rest, just use StringTokenizer...
}

[Joanne Neal]

Don't forget to allow for values that have commas embedded in them and for blank values, and probably other quirks of csv that I haven't thought of.
There are a number of java csv parsers available that handle all these things. Try googling 'java csv parser' - it's better than reinventing the wheel.

[Milan Jagatiya]

hi,
try below link..CSV Parser will helps you....
http://ostermiller.org/utils/CSV.html

enjoy......
milan.