在Java中拆分包含额外逗号和引号的CSV文件

Question

我需要解析一个一列的CSV文件，它不仅有额外的逗号，而且一些名称还包括额外的引号。我已经看过了，并阅读了之前的其他问题，最好的答案之一是阿钦蒂亚·杰哈的答案。然而，这种解决方案似乎在我的情况下不起作用。一个例子是这个名字

ADAMS COUNTY SHERIFF "ADAMS COUNTY SHERIFF'S OFFICE, CO"

正在打印为：

ADAMS COUNTY SHERIFF 
"ADAMS COUNTY SHERIFF'S OFFICE, CO"

它在正确的地方分裂，并且正在处理额外的逗号，但它没有击中额外的引号，并且现在也在那里分裂，所以String csvSplitBy = ",(?=([^\"]*\"[^\"]*\")*[^\"]*$)"; 将无法工作。有人知道Java处理这个问题的另一种方法吗？其他人问这个问题的答案用其他语言，但我找不到任何，除了我链接的，关于Java。谢谢！

package csvdatacompareapplication;
import java.io.*;

public class CSVDataCompareApplication {
    public static void main(String[] args) {

        BufferedReader br = null;
        BufferedReader br2 = null;
        String customerListAllCustomers = "C:\\Users\\Desktop\\customerListAllCustomers.csv";
        String customerListToRemove = "C:\\Users\\Desktop\\customerListToRemove.csv";
        String line = "";
        String csvSplitBy = ",";

        try {
            br = new BufferedReader(new FileReader(customerListAllCustomers));
            while ((line = br.readLine()) != null) {
                // use comma as separator
                //String [] customersAll = line.split(csvSplitBy);
                System.out.println(line);
            }
        } catch (FileNotFoundException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        } finally {
            if (br != null) {
                try {
                    br.close();
                } catch (IOException e) {
                    e.printStackTrace();
                }
            }
        }
    }

}

ADAMS COUNTY SHERIFF'S OFFICE, CO
ADAMSON POLICE PRODUCTS
ADAN DAVILA
ADAPT SECURE
ADDISON PD - MIKE VINCENT
ADDISON POLICE - IL
ADDISON PORTER
ADIN MCGARVIE
ADMIRAL FIRE & SAFETY
ADMON IRAMIYA
ADRIAN DANG
ADRIAN HUMPHRIES
ADRIAN KEPKA
ADRIAN SALDANA
ADRIAN SOLER
ADRIAN YORK
ADRIENNE BAKER
ADRIENNE MOOS
ADS INC.
ADS, INC

我更新了我的java代码，现在这是打印出来的

"ADAMS COUNTY SHERIFF'S OFFICE, CO"
ADAMSON POLICE PRODUCTS
ADAN DAVILA
ADAPT SECURE
ADDISON PD - MIKE VINCENT
ADDISON POLICE - IL
ADDISON PORTER
ADIN MCGARVIE
ADMIRAL FIRE & SAFETY
ADMON IRAMIYA
ADRIAN DANG
ADRIAN HUMPHRIES
ADRIAN KEPKA
ADRIAN SALDANA
ADRIAN SOLER
ADRIAN YORK
ADRIENNE BAKER
ADRIENNE MOOS
ADS INC.
"ADS, INC"

为什么要把引号放在里面？




Answer 1

感谢Andreas和Tamas Hegedus帮助您澄清问题！尝试：

        br = new BufferedReader(new FileReader(customerListAllCustomers));
        while ((line = br.readLine()) != null) {
            // one column, so don't need to use comma as separator
            String line2 = line.replaceAll("^\"","").replaceAll("\"$","").replaceAll("\\\"","\"");
            System.out.println(line2);

replaceAll调用带前导引号（^\“）和尾随引号（\“$），然后取消对其余引号的scape（\\\\”）。