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

Paul Ramsey pramsey at cleverelephant.ca
Mon Mar 30 06:51:00 PDT 2020


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


More information about the postgis-users mailing list