简单实现原理:
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();
}
}
}