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

[Shaozhong SHI]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200330/a38e7dc1/attachment.html>