Postgres Pro
Downloads
Home   >   mailing lists

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

From David G. Johnston
Subject Re: Unexpected Results from regexp_replace
Date
Msg-id CAKFQuwa=0hMEcrJf0RkNW9TtHQ6d6YeEu2j3QJMVEeVWxua5GQ@mail.gmail.com
Whole thread Raw
In response to Unexpected Results from regexp_replace  (Susan Hurst <susan.hurst@brookhurstdata.com>)
Responses Re: Unexpected Results from regexp_replace
List pgsql-general
Tree view
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.​


pgsql-general by date:

Previous
From: Susan Hurst
Date:
Subject: Unexpected Results from regexp_replace
Next
From: Susan Hurst
Date:
Subject: Re: Unexpected Results from regexp_replace