如何使用 CSVWriter 仅在 csv 中嵌入的逗号字符串上使用双引号? [英] How to have double quotes only on embedded comma String in csv using CSVWriter?

问题描述

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

This is my expected result format in the output 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 来实现这一点?

Can anyone suggest to me how to achieve this using OpenCSV framework's CSVWriter?

推荐答案

您可以使用 CsvWriter::writeNext 方法，该方法也需要一个 boolean 来指示是否使用总是引用，或仅在需要时引用.

You can use the CsvWriter::writeNext method which also takes a boolean to indicate whether to use quotes always, or only when needed.

来自 文档:

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

applyQuotesToAll - True if all values are to be quoted. False applies quotes only to values which contain the separator, escape, quote, or new line characters.

示例:

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

这篇关于如何使用 CSVWriter 仅在 csv 中嵌入的逗号字符串上使用双引号?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！