Re: converting .xls to delimited file

Поиск
Список
Период
Сортировка
От Jason Earl
Тема Re: converting .xls to delimited file
Дата
Msg-id 20010110145542.91618.qmail@web10014.mail.yahoo.com
обсуждение исходный текст
Ответ на converting .xls to delimited file  (William Staniewicz <wstan@localhostnl.demon.nl>)
Список pgsql-novice
The easiest way to convert an Excel file to a
delimited file would be to open the file in Excel and
save it as "Formatted Text (Tab Delimited)" or "CSV
(Comma Delimited)" file.  If you need to make the
conversion on a *NIX box take a look at Gnumeric.  It
does a very good job (in my experience) of reading
Excel files, and it can then save those files in a
variety of text-based formats.

Once the file is in some sort of text based format you
can use a wide variety of tools to further process it
(including sed).

I hope this is helpful,
Jason Earl

--- William Staniewicz <wstan@localhostnl.demon.nl>
wrote:
> Is there any way to convert an Excel file (".xls")
> to a delimited file? Maybe using sed?
>
>             Bill
>


__________________________________________________
Do You Yahoo!?
Yahoo! Photos - Share your holiday photos online!
http://photos.yahoo.com/

В списке pgsql-novice по дате отправления:

Предыдущее
От: David Merrill
Дата:
Сообщение: Re: converting .xls to delimited file
Следующее
От: Alfonso Peniche
Дата:
Сообщение: Re: converting .xls to delimited file