Re: Unexpected Results from regexp_replace - Mailing list pgsql-general

Excellent!  I tried the global flag before but I had it in the wrong
place.

Thanks for the quick service, David!

---
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Susan E Hurst
Principal Consultant
Email: susan.hurst@brookhurstdata.com
Mobile: 314-486-3261

On 2015-11-10 14:19, David G. Johnston wrote:
> On Tue, Nov 10, 2015 at 1:12 PM, Susan Hurst
> <susan.hurst@brookhurstdata.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.​