[Issue 126805] Importing CSV where apostrophe is separator and contained in text causes remaining rows to not import

[bu...@apache.org]

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

--- Comment #7 from damjan@apache.org ---
(In reply to Kay from comment #6)
> Results of my test with Linux-32 r. 1739631
> 
> The file imports completely. However line 124, second field from the
> original file as:
> 
> 'ARLINGTON INT'L AVIATION'
> 
> gets imported as:
> 
> ARLINGTON INTL AVIATION'
> 
> when I use the following as CSV import specifications:
> 
> * text separator -- comma
> * text deliminitor -- ' (single quote)
> 
> So the internal quote in INT'L gets dropped.

Which is exactly what Excel does in its "Text to columns" with that line, and
which is how it generally works: fields starting with the quote character
continue until the first quote character without an adjacent quote character,
and then any subsequent text is appended as it is, without considering quoting
at all.

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