Re: converting .xls to delimited file

From: David Merrill <dmerrill(at)lupercalia(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: converting .xls to delimited file
Date: 2001-01-10 13:37:02
Message-ID: 20010110083702.B13837@lupercalia.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

On Wed, Jan 10, 2001 at 11:22:46AM -0500, William Staniewicz wrote:
> Is there any way to convert an Excel file (".xls")
> to a delimited file? Maybe using sed?

You can export an excel file, from within excel, to tab delimited,
comma delimited, and many other formats. xls is a binary format, so
sed will not do the job.

--
Dr. David C. Merrill http://www.lupercalia.net
Linux Documentation Project dmerrill(at)lupercalia(dot)net
Collection Editor & Coordinator http://www.linuxdoc.org
Finger me for my public key

Three from the hall beneath the tree
Is, Was, and Shall Be
Come Wyrd Sisters swoop to the ground
Loosen the web that binds us down
Join with the hands of the Weavers Three
Is, Was, and Shall Be
-- Is, Was, and Shall Be, Beverly Frederick

In response to

Browse pgsql-general by date

  From Date Subject
Next Message rob 2001-01-10 13:40:53 Re: trouble with db-restore
Previous Message Richard Francis Duggan 2001-01-10 13:32:03 Creating a database

Browse pgsql-novice by date

  From Date Subject
Next Message Jason Earl 2001-01-10 14:55:42 Re: converting .xls to delimited file
Previous Message Brian E. Pangburn 2001-01-10 12:49:11 Re: converting .xls to delimited file