On 12 Feb 2002 09:25:51 -0500, Paul Kraus <[EMAIL PROTECTED]> wrote:
> How do Import a pipe deliminated text file into an openoffice.org
> spreadsheet?
Assuming that OpenOffice.org can't do it itself...
Have a look to see if there is any way to convert this file into a format that
can be read in OpenOffice.org, via another app like StarOffice 5.2, Gnumeric,
Kspread or even Excel (in WinDOS).
If that doesn't work, try opening the file in a text editor and doing a search
and replace to change all pipe symbols to commas. The resulting file will be in
CSV (Comma Separated Value) format. This format can be read by most
spreadsheets.
--
Sridhar Dhanapalan
Windows - 32 bit extensions and a graphical shell
for a 16 bit patch to an 8 bit operating system
originally coded for a 4 bit microprocessor,
written by a 2 bit company
that can't stand 1 bit of competition!
Want to buy your Pack or Services from MandrakeSoft?
Go to http://www.mandrakestore.com
