Re: [GENERAL] Re: Re: SQL Join - MySQL/PostgreSQL difference? - Mailing list pgsql-sql

From Brett W. McCoy
Subject Re: [GENERAL] Re: Re: SQL Join - MySQL/PostgreSQL difference?
Date
Msg-id Pine.LNX.4.30.0102071157540.14692-100000@chapelperilous.net
Whole thread Raw
In response to Re: Re: SQL Join - MySQL/PostgreSQL difference?  (Brice Ruth <brice@webprojkt.com>)
List 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.


pgsql-sql by date:

Previous
From: clayton cottingham
Date:
Subject: Re: Re: SQL Join - MySQL/PostgreSQL difference?
Next
From: Stephan Szabo
Date:
Subject: Re: Is this a bug, or is it just me?