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");

    }

}