你还在为了整理csv文件而头疼吗？-----筛选个人信息分类运营商

最新推荐文章于 2023-03-16 20:07:53 发布

sinat_39495176

最新推荐文章于 2023-03-16 20:07:53 发布

阅读量1k

点赞数

文章标签： java

本文链接：https://blog.csdn.net/sinat_39495176/article/details/79178527

版权

简单实现原理：

1.首先定义三个运营商的手机号码正则格式。

2.使用流将csv文件进行读取到内存中。

3.判断非空循环读取。

4.定义手机归属地为空串，定义写出文件类型。

5.将条件进行正则判断后以某种格式输出。

下面直接贴出代码：

import java.io.BufferedReader;
import java.io.BufferedWriter;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileWriter;
import java.io.IOException;
import java.io.InputStreamReader;

public class Readcsv {
   private static final String TELECOM = "(^1(33|53|77|8[019])\\d{8}$)|(^1700\\d{7}$)";// 电信
   private static final String UNICOM = "(^1(3[0-2]|4[5]|5[56]|7[6]|8[56])\\d{8}$)|(^1709\\d{7}$)";// 联通
   private static final String MOBILE = "(^1(3[4-9]|4[7]|5[0-27-9]|7[8]|8[2-478])\\d{8}$)|(^1705\\d{7}$)";// 移动

   public static void main(String[] args) {
       try {
           /**
           * 读取
           */
           InputStreamReader isr = new InputStreamReader(new FileInputStream("C:\\test1.csv"), "GBK");
           BufferedReader reader = new BufferedReader(isr);
           reader.readLine();
           String line = null;
           while ((line = reader.readLine()) != null) {
               String item[] = line.split(",");
               String idcard = item[0];
               String name = item[1];
               String gender = item[2];
               String age = item[3];
               String province_name = item[4];
               String city_name = item[5];
               String district_name = item[6];
               String phone = item[7];
               String etl_date = item[8];
               System.out.println(idcard + " " + name + " " + gender + " " + age + " " + province_name + " "
                       + city_name + " " + district_name + " " + phone + " " + etl_date);
               /**
               * 写入
               */
               String operator = "";// 手机号归属地
               File csv = new File("test2.csv");
               BufferedWriter bw = new BufferedWriter(new FileWriter(csv, true));
               if (phone.matches(TELECOM)) {
                   operator = "电信";
                   bw.write("\"" + idcard + "\"" + "," + "\"" + name + "\"" + "," + "\"" + gender + "\"" + "," + "\"" + age
                           + "\"" + "," + "\"" + province_name + "\"" + "," + "\"" + city_name + "\"" + "," + "\"" + district_name
                           + "\"" + "," + "\"" + phone + "\"" + "," + "\"" + etl_date + "\"" + ","
                           + "\"" + operator + "\"");
                   bw.newLine();
               } else if (phone.matches(UNICOM)) {
                   operator = "联通";
                   bw.write("\"" + idcard + "\"" + "," + "\"" + name + "\"" + "," + "\"" + gender + "\"" + "," + "\"" + age
                           + "\"" + "," + "\"" + province_name + "\"" + "," + "\"" + city_name + "\"" + "," + "\"" + district_name
                           + "\"" + "," + "\"" + phone + "\"" + "," + "\"" + etl_date + "\"" + ","
                           + "\"" + operator + "\"");
                   bw.newLine();
               } else if (phone.matches(MOBILE)) {
                   operator = "移动";
                   bw.write("\"" + idcard + "\"" + "," + "\"" + name + "\"" + "," + "\"" + gender + "\"" + "," + "\"" + age
                           + "\"" + "," + "\"" + province_name + "\"" + "," + "\"" + city_name + "\"" + "," + "\"" + district_name
                           + "\"" + "," + "\"" + phone + "\"" + "," + "\"" + etl_date + "\"" + ","
                           + "\"" + operator + "\"");
                   bw.newLine();
               } else if(phone.matches("")){
                   operator = "无";
                   bw.write("\"" + idcard + "\"" + "," + "\"" + name + "\"" + "," + "\"" + gender + "\"" + "," + "\"" + age
                           + "\"" + "," + "\"" + province_name + "\"" + "," + "\"" + city_name + "\"" + "," + "\"" + district_name
                           + "\"" + "," + "\"" + phone + "\"" + "," + "\"" + etl_date + "\"" + ","
                           + "\"" + operator + "\"");
                   bw.newLine();
               }
               bw.close();
           }
       } catch (IOException e) {
           e.printStackTrace();
       }

   }
}