Re: cat infile | translate all occurences of "NOT NULL" to ""

Webb Sprague <wsprague100@yahoo.com>

From: Webb Sprague <wsprague100@yahoo.com>
To: Dan Browning <danb@cyclonecomputers.com>, pgsql-novice@postgresql.org, redhat-list@redhat.com, jsokel@mdsi-usa.com
Date: 2000-09-11T19:38:31Z
Lists: pgsql-novice
The easiest thing is probably to use vi.  Then write
	:s/"NOT NULL"/""/gc
the `g' will do each occurence, and the `c' will ask
for confirmation.  Once you are sure everything will
be fine, let it do `all'.

Otherwise, you can use `sed', but that is weird...

W
--- Dan Browning <danb@cyclonecomputers.com> wrote:
> what command do I use to substitute all occurences
> of a certain string (say,
> "NOT NULL") with another arbitrary string, (e.g.
> "")?  I've tried grep and
> tr, but can't figure it out.
> 
> Thanks,
> 
> Dan Browning
> Network & Database Administrator
> Cyclone Computer Systems
> 


__________________________________________________
Do You Yahoo!?
Yahoo! Mail - Free email you can access from anywhere!
http://mail.yahoo.com/