Re: Need help for import of text file - Mailing list pgsql-general

From Peter Bex
Subject Re: Need help for import of text file
Date
Msg-id 20121216233341.GD14498@frohike.homeunix.org
Whole thread Raw
In response to Re: Need help for import of text file  (Steve Clark <sclark@netwolves.com>)
List pgsql-general
On Sun, Dec 16, 2012 at 06:30:24PM -0500, Steve Clark wrote:
> why not use the squeeze option of tr.
>
> tr -s " "

I wasn't aware of that one, it's even simpler and more elegant.
Thanks!

For this particular case, tr(1) won't do for the same reason
the simple sed(1) expression I gave won't do: it should only
be applied to the data, not the extra 4 lines of meta-data.

Cheers,
Peter
--
http://sjamaan.ath.cx
--
"The process of preparing programs for a digital computer
 is especially attractive, not only because it can be economically
 and scientifically rewarding, but also because it can be an aesthetic
 experience much like composing poetry or music."
                            -- Donald Knuth


pgsql-general by date:

Previous
From: Steve Clark
Date:
Subject: Re: Need help for import of text file
Next
From: Edson Richter
Date:
Subject: Re: XML Schema for PostgreSQL database