Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index

On 24-12-2014 21:45, Constantine wrote:

After a lot of responses how to do this in Writer,
a shortnote how to do this in Calc..... ;-)

Open the textfile, when the 'Text import' wizzard is show do:
1) Select characterset 'Unicode (UTF-8)'
2) Separater options: 'separated by', check 'Tab' and 'Space', other 
options should not be checked.
3) at 'Text delimiter' type a space
4) klik 'OK'

5) Insert a column B, and fill it with a semi-colon ';'

6) Klik save-as, type a name, and check 'Edit filter settings'
7) The Export Text file' wizard should be shown.
8) Character set: 'Unicode (UTF-8)'
9) Field delimiter: space ' '
10) Text delimiter: <empty> ''
11) checkboxes: only leave 'Save cell content as shown' checked.....

Hi Luuk,

I am afraid this doesn't work. I thought of it myself and also tried it at
the beginning of my work.
As I said, Terms consist of 2-5 words, so when using space as separator
there is no way to insert a column (especially B) for the semicolon. Besides
definitions are sometimes so long with so many spaces, that calc reports not
being able to create enough columns for the whole content.

The correct and professional way is what Brian suggested and I was looking
Now I can use these expressions in the future too because the need for their
usage occurs very often in mine kind of work.

View this message in context:
Sent from the Users mailing list archive at

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.