csv - 这是有效的 CSV 转义吗？ Lumenworks 抛出异常但其他解析器似乎工作

Question

我正在更新解析 CSV 的遗留系统。我决定使用 LumenWorks .csv 库。它在这样的记录上挣扎:

"Cats","123","A","B","Mittens","1","2","3","1950",""PROBLEM IS HERE"","Some street","Fishtown","","AB13DF","United Kingdom","","","","","","","United Kingdom","Fiddles"

据我所知，这应该转义为 """PROBLEM IS HERE"""。任何人都可以确认吗？如果有效，则我需要找到修复方法，但如果无效，我可以通知客户他们提供的 CSV 格式不正确。

此外，如果有一种使用 LumenWorks 的方法(理想情况下是一种非黑客方法)可以防止它抛出异常，那将是一件好事。谢谢!

我应该补充一点，LumenWorks 给我这个:LumenWorks.Framework.IO.Csv.MalformedCsvException: The CSV appears to be corrupt near record ...

Answer 1

虽然 Lumenworks 网站未指定它符合 RFC 4180 ，当前预期的转义被指定为:

7. If double-quotes are used to enclose fields, then a double-quoteappearing inside a field must be escaped by preceding it withanother double quote. For example:

"aaa","b""bb","ccc"

因此，要包含字符串 "PROBLEM IS HERE"，您需要将引号加倍，生成 ""PROBLEM IS HERE""，然后将其括在双引号中引用，生成 """PROBLEM IS HERE"""。