Sorting data from a csv file
Hi All,
I currently can read a csv file into my console using:
BufferedReader in = new BufferedReader(new FileReader("/Users/Admin/Desktop/list.csv"));
int numberOfRows = 0;
int numberOfColumns = 0;
String line;
while ((line = in.readLine()) != null) {
System.out.println(line);
if(line!= null){
numberOfRows++;
StringTokenizer st = new StringTokenizer(line, ",");
numberOfColumns= st.countTokens();
}
}
System.out.println("Number of Rows: " + numberOfRows);
System.out.println("Number od Columns: " + numberOfColumns);
in.close();
}
My output:
Full Name,Email,Phone,Street Address,City,State,Zip
James Madison,jmadison@whitehouse.gov,201-555-1234,12 Main Street,Newark,NJ,11346
theodore roosevelt, teddy@whitehouse.gov, 415-555-1234, 1239 Geary, San Francisco, CA,95412
Franklin Roosevelt, fdr@whitehouse.gov, 718-555-1234, 805 New York Avenue, Brooklyn, NY,11257
Abe Lincoln, abe@whitehouse.gov, 312-555-1234, 22 Michigan Avenue, Chicago, IL,35124
Ronald Reagan, rreagan@whitehouse.gov, 261-555-1234, 14 Main Street, Columbus, OH,35214
bill clinton, bigbill@hotmail.com, 914-555-1234, 128 Readers Digest Road, Chappaqua, NY,10538
Number of Rows: 7
Number od Columns: 7
How can I sort this by ful name, then write to a file, then sort by state, then write to another file?
Any help would be appreciated.
ike
