https://bz.apache.org/ooo/show_bug.cgi?id=126805
--- Comment #8 from Kay <[email protected]> --- (In reply to damjan from comment #7) > (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. Ah. OK. I haven't used Excel in many many years. -- You are receiving this mail because: You are the assignee for the issue.
