Skip to Content
Sep 03, 2020 at 08:30 PM

Alternate character is appended at the end of string using regex_replace function in SAP BODS.


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!