时间戳

首页 > 解决方案 > 如何使用 CSVWriter 仅在 csv 中嵌入的逗号字符串上使用双引号？

java - 如何使用 CSVWriter 仅在 csv 中嵌入的逗号字符串上使用双引号？

问题描述

这是我在输出 csv 中的预期结果格式：

header1,header2,header3,header4
monica,chandler,"rachel,ross",joey

我目前的结果：

策略1：

CSVWriter csvWriter = new CSVWriter(new FileWriter("D:/new.csv"));
String[] headers = new String[] { "header1", "header2", "header3", "header4"};    
String[] arr = new String[] { "monica", "chandler", "rachel,ross", "joey"};


result:
"header1","header2","header2","header4"
"monica","chandler","rachel,ross","joey"

策略2：

CSVWriter csvWriter = new CSVWriter(new FileWriter("D:/new.csv"), CSVWriter.DEFAULT_SEPARATOR,CSVWriter.NO_QUOTE_CHARACTER, CSVWriter.DEFAULT_ESCAPE_CHARACTER, CSVWriter.DEFAULT_LINE_END);
    String[] headers = new String[] { "header1", "header2", "header3", "header4"};    
    String[] arr = new String[] { "monica", "chandler", "rachel,ross", "joey"};


result:
header1,header2,header2,header4
monica,chandler,rachel",ross,joey

谁能建议我如何使用 OpenCSV 框架的 CSVWriter 来实现这一点？

标签： javaspringcsvapache-camelopencsv

解决方案

您可以使用CsvWriter::writeNext也带 a 的方法boolean来指示是始终使用引号，还是仅在需要时使用引号。

从文档中：

applyQuotesToAll- 如果要引用所有值，则为真。False 仅将引号应用于包含分隔符、转义符、引号或换行符的值。

一个例子：

try (CSVWriter csvWriter = new CSVWriter(new FileWriter("new.csv"))) {
    String[] headers = new String[]{"header1", "header2", "header3", "header4"};
    String[] arr = new String[]{"monica", "chandler", "rachel,ross", "joey"};
    csvWriter.writeNext(headers, false);
    csvWriter.writeNext(arr, false);
}

结果：

header1,header2,header3,header4
monica,chandler,"rachel,ross",joey

推荐阅读