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

in vi you can type : and then 1,$s/oldstring/newstring/g
where 1 means start from the first line, $ means until the end of the file,
oldstring is what you want to replace, newstring is what you want to replace
it with, and the g means do it globally throughout the file.

e.g.    1,$s/NOT NULL//g     should work

Hope this helps
Tamsin

-----Original Message-----
From: pgsql-novice-owner@hub.org [mailto:pgsql-novice-owner@hub.org]On
Behalf Of Dan Browning
Sent: 11 September 2000 15:16
To: pgsql-novice@postgresql.org; redhat-list@redhat.com;
jsokel@mdsi-usa.com
Subject: [NOVICE] cat infile | translate all occurences of "NOT NULL" to
""


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