We have a requirement to remove all the character except (a-z, A-Z, 0-9) so we used regex_replace function.but it is working fine for some cases and in some cases some alternate character got added into end of string.
Syntax that we have used :- regex_replace(input,'\[^a-zA-Z0-9 \]','')
Anyone who faced the similar issue and how you overcome from this.
Many Thanks!