Horton

Re: Re: [SQL] Re: SQL Join - MySQL/PostgreSQL difference?

Brett W. McCoy <bmccoy@chapelperilous.net>

View thread View on postgr.es
From: "Brett W. McCoy" <bmccoy@chapelperilous.net>
To: Brice Ruth <brice@webprojkt.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Michael Fork <mfork@toledolink.com>, Ian Harding <iharding@pakrat.com>, <pgsql-general@postgresql.org>, <pgsql-sql@postgresql.org>
Date: 2001-02-07T16:58:48Z
Lists: pgsql-general, pgsql-sql 
On Wed, 7 Feb 2001, Brice Ruth wrote:

> Is there a simple (unix) command I can run on text files to convert
> cr/lf to lf?  The way I did it seemed pretty ass-backward to me (not to
> mention time consuming).

perl -pi -e 's/\cM\\g' <filename>

will do the trick, assuming you have Perl instaleld on your system.

-- Brett
                                     http://www.chapelperilous.net/~bmccoy/
---------------------------------------------------------------------------
Money will say more in one moment than the most eloquent lover can in years.