CSVFormat.RFC4180 忽略文件中.csv引号值

Question

我有.csv带有引号值的文件

Gender,ParentIncome,IQ,ParentEncouragement,CollegePlans
"Male",53900,118,"Encouraged","Plans to attend"
"Female",24900,87,"Not Encouraged","Does not plan to attend"
"Female",65800,93,"Not Encouraged","Does not plan to attend"

使用以下代码读取此文件（使用 IntelliJ 并观察调试器中的值），返回不带引号的值。

@Override
    public CsvConnectorService read(String fullFileName, String outputAddress, int intervalMs, boolean repeat,
                                    Handler<AsyncResult<Void>> result) {
        CSVFormat format = CSVFormat.RFC4180.withHeader().withIgnoreEmptyLines().withQuote('"');
        Subscription subscription = createCsvObservable(fullFileName, format, intervalMs, repeat)
                .subscribeOn(Schedulers.io())
                .subscribe(record ->
                        eventBus.publish(outputAddress, convertRecordToJson(record)));
        subscriptions.add(subscription);
        result.handle(Future.succeededFuture());
        return this;
    }

有.withQuote('"');或没有阅读，都没有区别。

Answer 1

引

号"是表示带引号字段的默认字符，显式设置它没有区别。

您想获取原始引号字符吗？在这种情况下，请尝试将引号设置为文本中未出现的字符，例如.withQuote('');