Re: [SQL] Re: SQL Join - MySQL/PostgreSQL difference?
Christopher Sawtell <csawtell@xtra.co.nz>
From: Christopher Sawtell <csawtell@xtra.co.nz>
To: Brice Ruth <brice@webprojkt.com>, Tom Lane <tgl@sss.pgh.pa.us>
Cc: Michael Fork <mfork@toledolink.com>, Ian Harding <iharding@pakrat.com>, pgsql-general@postgresql.org, pgsql-sql@postgresql.org
Date: 2001-02-07T22:00:42Z
Lists: pgsql-general, pgsql-sql
On Thu, 08 Feb 2001 05:38, 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). This little heiroglyph will convert all text files rescued from that man's system in a single directory to the format required by the one true way. for f in `echo *`; # Change this to select files by regex if needed do echo $f; cat $f | tr -d "\015\032" > $f.unix; mv $f.unix $f; done Don't forget to remove the control Z file terminator as well as the superfluous CRs. It could cause very obtuse problems. Assumes you have write permission to the directory.