On Wed, 31 Oct 2001, Andrew Gould wrote:
> 2. There's a huge fixed width file that I receive
> every quarter. Since the structure is the same, I
> wrote a python script that copies the data to a new
> file, inserting tab delimiters and stripping out the
> extra spaces as it goes. The resulting file is often
> one third the size of the original. I then use copy
> to import the tab delimited data into PostgreSQL.
I've done the same thing using perl. In fact I have actually just
read, parsed, and then inserted the data directly into PostgreSQL.
Cheers,
Rod
--
Let Accuracy Triumph Over Victory
Zetetic Institute
"David's Sling"
Marc Stiegler