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 по дате отправления: