Regular expressions: remove non alpha numerics, with an exception

regex postgresql

Then you need to use :

x = regexp_replace(somestring, '\W+', '', 'g')

\W is the same as [^a-zA-Z0-9_]

regex postgresql

How about using '\W+' that replaces all non a-z and 0-9 leaving _ alone

x = regexp_replace(somestring, '\W+', '', 'g')

CodeHunter