英文:
How to escape linebreak character while writing a csv with java/opencsv
问题
我有一个CSV文件，它被保存为一个Bean。其中一列包含HTML标签，包括\n字符。使用opencsv读取时没有问题，但当我写一个新的CSV文件时，它实际上创建了一个新的换行/行。
这是我尝试过的方法：
File file = new File(outDirectory, this.outputCSVName);try (Writer writer = Files.newBufferedWriter(Paths.get(file.toURI()));) {StatefulBeanToCsv<Shopify> beanToCsv = new StatefulBeanToCsvBuilder(writer).withQuotechar(CSVWriter.NO_QUOTE_CHARACTER).withApplyQuotesToAll(true).withEscapechar('\n').withLineEnd("\n") // 仅用于测试.withSeparator(',').build();beanToCsv.write(data);writer.close();} catch (CsvRequiredFieldEmptyException | IOException e) {throw new RuntimeException(e);} catch (CsvDataTypeMismatchException e) {throw a RuntimeException(e);}
以及在ArrayList中的样子：
如何将其写入字符串？还如何将其导出为UTF-8编码的文件？
英文:
I have a CSV file, which is saved as a Bean. One column has HTML tags including \n character. While reading with opencsv is not a problem, but when i write a new csv it actually creates a new line break/row. 
Here is what i have tried:
File file = new File(outDirectory, this.outputCSVName);try (Writer writer = Files.newBufferedWriter(Paths.get(file.toURI()));) {StatefulBeanToCsv<Shopify> beanToCsv = new StatefulBeanToCsvBuilder(writer).withQuotechar(CSVWriter.NO_QUOTE_CHARACTER).withApplyQuotesToAll(true)[![enter image description here][1]][1].withEscapechar('\n').withLineEnd("\n") // just to test.withSeparator(',').build();beanToCsv.write(data);writer.close();} catch (CsvRequiredFieldEmptyException | IOException e) {throw new RuntimeException(e);} catch (CsvDataTypeMismatchException e) {throw new RuntimeException(e);}
and here is how it looks like in the arraylist:
How can i write it as a string? Also how can i export it as a UTF-8 encoded file?
答案1
得分: 0
@g00se的建议让我移除了*.withEscapechar('\n')*，之后它就正常工作了。我的最终导出结果如下：File file = new File(outDirectory, this.outputCSVName);try (Writer writer = Files.newBufferedWriter(Paths.get(file.toURI()), StandardCharsets.UTF_8);) {StatefulBeanToCsv<Shopify> beanToCsv = new StatefulBeanToCsvBuilder(writer).withSeparator(',').build();beanToCsv.write(data);writer.close();return "导出成功";} catch (CsvRequiredFieldEmptyException | IOException e) {throw new RuntimeException(e);} catch (CsvDataTypeMismatchException e) {throw new RuntimeException(e);}
英文:
The suggestion of @g00se made me remove the .withEscapechar('\n') and after that it worked fine. My final Export looks like this:
File file = new File(outDirectory, this.outputCSVName);try (Writer writer = Files.newBufferedWriter(Paths.get(file.toURI()), StandardCharsets.UTF_8);) {StatefulBeanToCsv<Shopify> beanToCsv = new StatefulBeanToCsvBuilder(writer).withSeparator(',').build();beanToCsv.write(data);writer.close();return "Export OK";} catch (CsvRequiredFieldEmptyException | IOException e) {throw new RuntimeException(e);} catch (CsvDataTypeMismatchException e) {throw new RuntimeException(e);}
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论