[ic] Re: [NOVICE] Removing all instances of "NOT NULL" from an entire directory of files

ERIC Lawson - x52010 eric@bioeng.washington.edu
Tue, 12 Sep 2000 08:26:55 -0700 (PDT)

(In tcsh; other shells have similar/equivalent syntax.)

At the shell prompt:

foreach i (*.sql)
echo $i
cp $i $i.bkp

I'm using echo and cp to illustrate the syntax only; your command(s) would
go in their place.

James Eric Lawson
Research Publications Editor III
National Simulation Resource


On Mon, 11 Sep 2000, Dan Browning wrote:

> OK, I've got a command (or two) that will remove all NOT NULL strings from a
> given file.
> 	cat filename | perl -pi -e "s/NOT NULL//g" > filename
> But how do I run that command on every file in a directory, successively?
> (In case you're wondering, I'm working on the pgsql/ directory of .sql files
> that interchange uses to build the database tables).
> Thanks,
> Dan Browning
> Network & Database Administrator
> Cyclone Computer Systems