https://bz.apache.org/ooo/show_bug.cgi?id=126805

bmarcelly <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[email protected]

--- Comment #2 from bmarcelly <[email protected]> ---
If apostrophe is used as text delimiter, a single apostrophe must not appear
within a text field. This is a matter of logic.

Within a text any apostrophe must be doubled.

Line 124 should be :
'ARLINGTON IN','ARLINGTON INT''L
AVIATION','150227','12/18/2015','470','35','02/02/2016'

With this modification the entire file is imported correctly.

See also https://tools.ietf.org/html/rfc4180 section 2 point 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"

-- 
You are receiving this mail because:
You are the assignee for the issue.

Reply via email to