regex - Need regular expression for restricting special characters -

regex - Need regular expression for restricting special characters -

i need replace next special characters empty string.

™,®,',(tm),(r),é,�,’,–,â€

i using trim(regexp_replace(:desc, '(*[\\™®])', ' '))

but failing. tool sql loader.

thanks in advance

regex:

[™�®'’é–]|â€|\((?:tm|r)\)

replacement string:

empty string.

demo

regex oracle sql-loader