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@xxxxxxxxxxxxxxxxxx
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@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.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
