[plug] OO.o- Importing delimeted text files to spreadsheet

[Anthony J. Breeds-Taurima]

On Wed, 18 Dec 2002, Tim Bowden wrote:

> Hi all,
> 
> I have a text file of point coordinates that I need to import.  It is 
> delimeted with a rather unusual delimiter: |
> 
> I need to find a way to set the delimeter character & so on, but oo.o 
> wants to open it as a text document, rather than importing it to a 
> spreadsheet.  How do I get around this?  Cutting and pasting from the 
> text document doesn't work- the delimeter is ignored.

Open the spreadsheet
File::Open
Select "Text CSV" for the file type.
Slect your file and work through the import wizard.
You can specify '|' as an "other delimiter.

HTH


Yours Tony

   Jan 22-25 2003           Linux.Conf.AU            http://linux.conf.au/
		  The Australian Linux Technical Conference!