Adams Basic Package > Adams View > View Function Builder > Design-Time Functions > Functions: R - S > STR_REPLACE_ALL

STR_REPLACE_ALL

Returns a string constructed by replacing all the occurrences of the sub string in an input string with another string

Format

STR_REPLACE_ALL (Destination String, Old Sub String, New Replace String)

Argument

 
Destination String
Text string.
Old Sub String
Text string to replace in destination string
New Replace String
Text string to be replace with old sub string in destination string

Example

The following function returns string constructed by replacing all the occurrence of old sub string with new string
 
Function
str_replace_all("aabbccaaaeeffaaaa","aa","cba")
Result
"cbabbcccbaaeeffcbacba"
Learn more about string functions.