How to replace special character in string

Question

I have the string with multiple repeated special characters which needs to be replaced with another character. 
 
 Eg: s'd'g' has to be replaced with s@d@g@. 
 
 Please suggest.

Mike Schmitt · Accepted Answer

Since nobody's said so already, I suggest you check out the function substitute() . 
 j/k 
 
 Seriously though, I would like to offer the following expression rule which you can use to do multiple simultaneous substitutions. It accepts 2 equal-length arrays, ri!originalValues which will be replaced by the members of ri!replacementValues. Original text is ri!inputText. 
 if( count(ri!originalValues) <> count(ri!replacementValues), ri!inputText, reduce( fn!substitute, ri!inputText, merge( ri!originalValues, ri!replacementValues ) ) )

Aswini · Answer

Hi saic, 
For replacing special characters in string you can use substitute() function. 
 
for example : substitute("A'P'P'I'A'N","'","@"). The output will be A@P@P@I@A@N 
 
 docs.appian.com/.../fnc_text_substitute.html

aratim · Answer

Hi, 
Substitute function can be useful to get the required output: 
Link for more info: docs.appian.com/.../fnc_text_substitute.html 
Input: substitute("s'd'g'","'","@") 
Output : s@d@g@ 
 
Thanks.

How to replace special character in string

Top Replies