正则表达式划分CSV

发布时间：2020-12-14 01:45:42 所属栏目：百科来源：网络整理

导读：《精通正则表达式》第401页 public static List splitCSV (String txt) { String reg = " G(?:^|,)(?:"([^"]*+(?:""[^"]*+)*+)"|([^",]*+)) "; // 即 G(?:^|,)(?:"([^"]*+(?:""[^"]*+)*+)"|([^",]*+)) Matcher matcherMain = Pattern.compile(reg

《精通正则表达式》第401页

public static List splitCSV(String txt) {

String reg = " G(?:^|,)(?:"([^"]*+(?:""[^"]*+)*+)"|([^",]*+))";

// 即 G(?:^|,)(?:"([^"]*+(?:""[^"]*+)*+)"|([^",]*+))

Matcher matcherMain = Pattern.compile(reg).matcher("");

Matcher matcherQuoto = Pattern.compile(" """).matcher("");

matcherMain.reset(txt);

System.out.println(matcherMain.groupCount());

List strList = new ArrayList();

while (matcherMain.find()) {

String field;

if (matcherMain.start(2) >= 0) {

field = matcherMain.group(2);

} else {

field = matcherQuoto.reset(matcherMain.group(1)).replaceAll(""");

}

strList.add(field);

}

return strList;

}

//测试

public static void main(String[] args) {

String txt = " The Thousand,10000,2700,"10,000","It's ""10 Grand"",baby",10K ";

//即 The Thousand,"10,000","It's ""10 Grand"",baby",10K

List splits = splitCSV(txt);

for (String s : splits) {

System.out.println(s);

}

打印：

The Thousand

10000

2700

10,000

It's "10 Grand",baby

10K

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!