[postgis-users] Is there a robust way to strip off special characters?

[Paul Ramsey]

Add the ‘g’ option. See the PgSQL docs 

> On Mar 30, 2020, at 3:10 AM, Shaozhong SHI <shishaozhong at gmail.com> wrote:
> 
> I ran the following code.
> 
> ---strip special characters
> area_name = regexp_replace(area_name, '[^\w]+','');
> 
> It only stripped away the first bracket - (.  But, it left the closing bracket ).
> 
> I had to run it twice in order to stripped the second.
> 
> Is there a robust way to strip off special characters?
> 
> Regards,
> 
> Shao
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users