https://bz.apache.org/ooo/show_bug.cgi?id=126805
--- Comment #7 from [email protected] --- (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.
