On Tue, Nov 10, 2015 at 1:12 PM, Susan Hurst <susan(dot)hurst(at)brookhurstdata(dot)com
> wrote:
> What is the trick for removing all instances of unwanted characters and
> spaces?
(g)lobal flag.
SELECT regexp_replace('hello - world n', '[^0-9a-z]+', '', 'g')
;
David J.