Tim Johnson wrote:
Hi:
Have files with following format:
First line:
column names, delimited by TABs, no text qualifiers
Following lines:
cells delimited by TABS.
I would like to import such a file into calc.
...
For importing text data in Calc, I use and recommend this:
1) Insert > Sheet From file
2) File name: data.text (e.g.)
3) File type: Text CSV -- It's not actually necessary to set the file
type, but I usually do it anyway, out of habit.
4) Click "Insert"
This will bring up the text import dialog window, where you can set your
separator character and column data types.
This works for files having any name or extension (i.e. no need to
rename your data file) and it avoids having OOo decide to open the file
in Writer, or indeed, having the data file opened at all. Opening a file
in OOo has a special meaning and can easily lead to losing work if you
open a text file. I generally avoid File > Open for anything except ODF
files.
<Joe
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
