[
https://issues.apache.org/jira/browse/CSV-294?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Joern Huxhorn updated CSV-294:
------------------------------
Summary: CSVFormat does not support " as escape char (was: Missing escape
character in CSVFormat.DEFAULT/RFC4180)
> CSVFormat does not support " as escape char
> -------------------------------------------
>
> Key: CSV-294
> URL: https://issues.apache.org/jira/browse/CSV-294
> Project: Commons CSV
> Issue Type: Bug
> Affects Versions: 1.9.0
> Reporter: Joern Huxhorn
> Priority: Major
>
> CSVFormat.DEFAULT or at least CSVFormat.RFC4180 and CSVFormat.EXCEL should
> have escape character set to '"' as defined in [RFC
> 4180|https://datatracker.ietf.org/doc/html/rfc4180].
> 7. If double-quotes are used to enclose fields, then a double-quote
> appearing inside a field must be escaped by preceding it with
> another double quote. For example:
> "aaa","b""bb","ccc"
>
> I just realized that '"' {*}doesn't work as escape character at all{*}.
> This... isn't good.
> This is also the way Excel escapes ", i.e. Excel is behaving as specified in
> RFC 4180 but commons-csv isn't.
>
> Related issue:
> https://issues.apache.org/jira/browse/CSV-150
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
