How to read csv file & which collection should be used ?

[Rahul B. Shah]

Hello,
Can anyone guide me how to read csv file & which collection is suitable.

csv file :
Name test
FirstName First_Name
LastName Last_Name

Name test2
FirstName First_Name
LastName Last_Name
Email User_Email

[Rob Spoor]

Our AccessingFileFormats FAQ lists a few libraries that can read CSV files.

[Rahul B. Shah]

Thanks Rob,
I have done following :

package csvreader;

import java.io.BufferedReader;
import java.io.FileReader;
import java.util.StringTokenizer;

public class ReadCSV 
{
	public static void main(String args[])
	{
		try
		{
			String csvFile="C:\\Documents and Settings\\Administrator\\My Documents\\Downloads\\Sample_input_lookup_file.csv";
			
			BufferedReader br = new BufferedReader(new FileReader(csvFile));
			String line = "";
			StringTokenizer st = null;
			int lineNumber=0;
			int tokenNumber=0;
			
			while((line = br.readLine()) != null)
			{
				lineNumber++;
				st = new StringTokenizer(line,",");
				while(st.hasMoreTokens())
				{
					tokenNumber++;
					System.out.println(st.nextToken());
				}
				System.out.println();
				tokenNumber = 0;
				
			}
		}
		catch(Exception e)
		{
			System.out.println("Cannot Read:"+e.toString());
		}
	}
}

I get following output on console :

# Lookup Name
Test Lookup 1

#Type
Refresh

First Name
FIRST_NAME

Last Name
LAST_NAME

ORGANIGATION
USER_ORGANIZATION



# Lookup Name
Test Lookup 2

#Type
Append

First Name
FIRST_NAME

Last Name
LAST_NAME

ORGANIGATION
USER_ORGANIZATION

Email
USER EMAIL

& now i am stuck on how to get these values so that i can use in my function ....

[Edit - added code tags - MB]

[Ulf Dittmer]

This code will not work for all CSV files, as it ignores several CSV features. CSV is not as trivial to parse as it first looks; that's why Rob pointed you to existing libraries,