Apache OpenOffice (AOO) Bugzilla – Issue 80393
text import
Last modified: 2007-08-07 13:29:26 UTC
When importing text (in my case from our database for creation of lists) the feature "seperator option" doesn't work: When pasting text into the spreadsheet the window "text import" opens. we use semicolons to seperate text and ' as text limiter, this combination doesn't result in seperate columns. If we apply only semicolons as seperator and leave the text limiter on the preset ", the columns are seperated. On the other hand, I tried to import text with semicolons as text seperator and " as text limitor. This resulted in the following: - with the set up: text seperator = Semicolon and text limiter= " , the program ignores some semicolons -with the set up: text seperator = semicolon and text limiter= ' , the programs seperates all columns, but ignores the text limiter It seems like a little mix-up in the programming there. Although I am not a specialsÃst myself... The text import feature seems like a new one to me, since I've only seen it in the new version. We are using the "Text to Column" add-on and therefore it's not a big problem. At least for us.
Hi, please attach a file showing your problem. Frank
Created attachment 47355 [details] examples of text import problems
Hi, this is not a bug. The semicolons are used as field delimiter and the quotes (or double quotes) are used to determine what is text, so you can have test;test;test which results in three cells of test after import. Making 'test;test;test' and set the text delimiter to single quote on import will open a single cell with content test;test;test . Your example mixes these settings up, making test;'test';test';'test;'test this an almost faulty snippet of csv data. So the information you need is that a starting quote needs an ending quote and all between these two quotes is interpreted as text. It's the way it must work according to the 'specifications'. So I have to close this Issue as invalid. Sorry for no better reply. Frank
closed inv