Posted: Tue Jan 16, 2007 4:58 am Post subject: help...
Sorry for troubling you.
I am a new user of neooffice. Do you know if an equivalent form of the Microsoft command ``text to columns'' is available? And what about to flip vertically a text? I see this command on the format menu, but how to use it?
Alberto, scusa, cosa fa "text to coloum" (sono anni che non uso Word).
Il testo verticale ti serve nei documenti di testo (cioè in Writer) o nei fogli elettronici (cioè in Calc)? Il testo verticale deve essere ruotato oppure semplicemente
a
l
l
i
n
e
a
t
o
After exchanging some PM I arrived to a possible solution for this, and maybe we could wiki it.
Neoalberto has some data arranged in a text file formatted like this
Code:
A B 6 pippo
C D 10 topolino
... ... ... ....
Fields are separated with different number of spaces and he wanted to obtain a table and possibly export this table in calc, so he can realize his own database with Base.
It's possible to replace all different number of spaces going to Edit -> Find & Replace, than hit on "More options" buttom and check "regular expression". Now in "Search for" type "[:space:]+" (without ") and in "Replace with" simply type a space (hit the space bar once). Now click on "Replace all" and than twice on OK.
Now we need to convert text into table so we select our data, click on Table -> Convert -> text to table. In Separated text at choose Other, replace the comma (,) with a space (hit space bar once), and that's it.
I'ts also possible to replace spaces with a tab. In this case you have to put in the Replace field "/t" (without "). Than you can choose tab in the "Separeted text at" to convert your text into a table.
If you want to move the table to Calc, just copy the table and paste it in Calc.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You cannot download files in this forum
)
Suggestions welcome