zhongyijie
发贴: 36
积分: 30
|
于 2003-07-24 14:22
package Test;
import java.io.*; import java.util.*;
public class CsvFileImport { private static String line = null; BufferedReader in = null;
/** * CsvFileImport constructor comment. */ public CsvFileImport() { super(); }
public static void main(String args[]){
try {
String fileName = "C:\\javatest\\CSVImport.csv"; BufferedReader in = new BufferedReader(new FileReader(fileName)); while((line = in.readLine()) != null){ StringTokenizer st=new StringTokenizer(line,","); int tokenCount=0; while(st.hasMoreTokens()){ tokenCount++; String token=st.nextToken(); if(token.indexOf("\"")!=-1){ //this token contains a " , so we should read the next one too String next; while((next=st.nextToken()).indexOf("\"")==-1) token+=next;//ugly,might use a stringbuffer //it might also break if csv incorrectly formed } System.out.println(token);//you now have your token here, do extra processing with it if(tokenCount==3){//this is the salary try{ double value=Double.parseDouble(token); value+=1000; token=String.valueOf(value); }catch(NumberFormatException e) {} } //now put the token in another file... //TODO } }
}
catch (IOException e) { System.err.println; }
} }
|