Re: Unexpected Results from regexp_replace

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Tue, Nov 10, 2015 at 1:12 PM, Susan Hurst <susan.hurst@xxxxxxxxxxxxxxxxxx> 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.​