Thank you Joe and Eric. regards tim On Thursday 21 August 2008, Joe Smith wrote: > 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]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
