ReplaceStr
ReplaceStr( value, find, replace )
ReplaceStr( value, find, replace )
ReplaceStr( value, find, replace )
ReplaceStr( value, find, replace )
replace_str( value, find, replace )
ReplaceStr( value, find, replace )
Description
The ReplaceStr
function returns a string which has all occurrences of
the find
sub-string replaced with the replace
string. Punctuation in
the find
string is interpreted literally and not as a pattern.
Returns
A new String which has all of the find
sub-strings replaced
with the replace
string.
Examples
The following query executes an array of independent ReplaceStr
operations and returns the results in an array. The result array
position matches the execution array position. The individual operations
are:
-
The string "One Fish Two Fish" is processed, replacing all instances of "Two" with "Blue". The result string "One Fish Blue Fish" is placed in the top position of the result array.
-
The string "One Fish Two Fish" is processed, replacing all instances of "Fish" with "CAT". The resultant string "One CAT Two CAT" is placed in the second position of the result array.
-
The string "One Fis? Two Fish" is processed, replacing all instances of the "Fis?" with "Fish". The resultant String "One Fish Two Fish" is placed in the third position of the result array.
Arr(StringV(One Fish Blue Fish), StringV(One CAT Two CAT), StringV(One Fish Two Fish))
[One Fish Blue Fish One CAT Two CAT One Fish Two Fish]
["One Fish Blue Fish", "One CAT Two CAT", "One Fish Two Fish"]
[ 'One Fish Blue Fish', 'One CAT Two CAT', 'One Fish Two Fish' ]
['One Fish Blue Fish', 'One CAT Two CAT', 'One Fish Two Fish']
[ 'One Fish Blue Fish', 'One CAT Two CAT', 'One Fish Two Fish' ]
Is this article helpful?
Tell Fauna how the article can be improved:
Visit Fauna's forums
or email docs@fauna.com
Thank you for your feedback!