java 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('\0');