使用CSVWriter编写字符串数组-有些带引号，有些不带引号

Question

我想打印如下内容：

abc、def、ghi、JKL、mno、pqr

我刚写的时候：

CSVWriter writer = new CSVWriter(new FileWriter(getFullPathToTestFile(), true));
String[] newLine = { "abc","def","ghi","jkl","mno","pqr" };
writer.writeNext(newLine);

所以我试着：

CSVWriter writer = new CSVWriter(new FileWriter(getFullPathToTestFile(), true), CSVWriter.DEFAULT_SEPARATOR, CSVWriter.NO_QUOTE_CHARACTER);
String[] newLine = { "abc","def","ghi","jkl","mno","pqr" };
writer.writeNext(newLine);

这给了我：

abc、def、ghi、jkl、mno、pqr

CSVWriter writer = new CSVWriter(new FileWriter(getFullPathToTestFile(), true), CSVWriter.DEFAULT_SEPARATOR, CSVWriter.NO_QUOTE_CHARACTER);
String[] newLine = { "abc","def","ghi","\""+"jkl"+"\"","mno","pqr" };
writer.writeNext(newLine);

Answer 1

首先：我假设您使用的是com.opencsv.csvwriter，我参考的是http://opencsv.sourceforge.net/apidocs/com/opencsv/csvwriter.html的文档

示例数组中的语法错误。abc,def,..如果你不引用它们，它可能应该是变量，所以它应该是

String[] newLine = { "abc","def","ghi","\"jkl\"","mno","pqr" };

另外，从我看到的文档中

CSVWriter(Writer writer, char separator, char quotechar, char escapechar, String lineEnd)

您可以尝试将引号添加到源代码中，并禁用转义

CSVWriter writer = new CSVWriter(new FileWriter(getFullPathToTestFile(), true), CSVWriter.DEFAULT_SEPARATOR, CSVWriter.NO_QUOTE_CHARACTER, CSVWriter.NO_ESCAPE_CHARACTER, CSVWriter.DEFAULT_LINE_END);

根据您的用例，这可能足够，但会中断，例如，如果您在任何值中有逗号。

作为替代方案，您可以编写自己的Writer实现，该实现接受CSVWriter的输出，并应用正则表达式在第n列添加引号。

CSVWriter writer = new CSVWriter(new RegexpReplaceWriter(new FileWriter(getFullPathToTestFile(), true)), CSVWriter.DEFAULT_SEPARATOR, CSVWriter.NO_QUOTE_CHARACTER, CSVWriter.NO_ESCAPE_CHARACTER, CSVWriter.DEFAULT_LINE_END);