package regionForKeywords; import java.io.*; /** * Created by huangjiahong on 2016/2/25. */ public class RegionKeywordExcelTransform { public static void main(String[] args) { String inputFileName="D:\\USER\\huangjiahong\\Desktop\\region.txt"; String outputFileName="D:\\USER\\huangjiahong\\Desktop\\regionKeywords.txt"; File file = new File(inputFileName); String line=null; int errline=0; int regionN=0; try { BufferedReader reader =new BufferedReader(new FileReader(file)); File outFile = new File(outputFileName); FileWriter write = new FileWriter(outputFileName, false); if(!outFile.exists()){ outFile.createNewFile(); } while (null != (line = reader.readLine())){ try { String[] lineSplit=line.split("\t"); String regionName=lineSplit[0]; regionN++; String keywords[]=lineSplit[1].split("\\|"); //专区名也索引进去 // if(regionN==1||regionN==15) { write.write(regionName + "\t" + regionN + "\t" + regionName + "\n"); for (String kw : keywords) { write.write(kw + "\t" + regionN + "\t" + regionName + "\n"); } // } }catch (ArrayIndexOutOfBoundsException a){ System.out.println((errline++)+":"+line); a.printStackTrace(); } } reader.close(); write.close(); } catch (IOException e) { e.printStackTrace(); } System.out.println("finished"); } }