At 18:42 21/11/2007 +0000, I wrote:
At 20:51 18/11/2007 -0500, Stephen Hamburger wrote:
If I have a file with a bunch of data laid out in lines like this:
20/02/04 08:41:54 107.690000 107.720000
When I open the file in the .calc program each line of data is
placed within a single cell (Cell "A")...is it possible to import
the data so each field is placed in a separate cell? So for
example the date is in the first cell, the time in the second cell, etc...
If you are using Windows (and possibly otherwise), here is what to do:
o Rename your text file so that its extension is .csv.
o Open the file from within OpenOffice or right-click the file and
choose Open With... and browse to OpenOffice.
o In the Text Import dialogue, put a tick by Space under "Separated
by" (and make any other desired adjustments).
o Choose OK.
The slightly roundabout second step above was to avoid the .csv file
opening in Writer instead of in Calc. But I was careless in writing
it out. If you use Open With... and browse to OpenOffice, the file
will still open in Writer: you need to browse to Calc explicitly
(scalc in Windows) to produce the desired effect if you choose this route.
Sorry about that.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
