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
[email protected]
https://lists.osgeo.org/mailman/listinfo/postgis-users

Reply via email to