myformatter.java

针对excel表中粘贴的数据

import java.io.BufferedReader;
import java.io.FileNotFoundException;
import java.io.FileReader;
import java.io.FileWriter;
import java.io.IOException;
import java.util.StringTokenizer;

public class MyFormatter {
	public static void main(String[] args) {
		FileReader fr = null;
		BufferedReader br = null;
		FileWriter fw=null;
		String sInput="";
		try {
			fr = new FileReader("needed.txt");
			br = new BufferedReader(fr);
			String s = null;
			int count =0;
			fw=new FileWriter("carbon.dat");
			while ((s = br.readLine()) != null) {
				sInput="";
				count =0;
				StringTokenizer st = new StringTokenizer(s," \t\n\r\f:");
				while (st.hasMoreTokens()) {
					if(count==0){
						sInput+=st.nextToken()+"    ";
						count++;
					}else{
						sInput+=(count++)+":"+st.nextToken()+"    ";
					}
			     }		
				sInput+="\n";
				fw.write(sInput);
			}
			br.close();
			fw.close();
			
			

		} catch (FileNotFoundException e) {
			e.printStackTrace();
		} catch (IOException e) {
			e.printStackTrace();
		}
	}

}