ReplaceStr

Not available in this language yet.
ReplaceStr( value, find, replace )
ReplaceStr( value, find, replace )
ReplaceStr( value, find, replace )
Not available in this language yet.
Not available in this language yet.
Not available in this language yet.
ReplaceStr( value, find, replace )

Description

The ReplaceStr function returns a string which has all occurrences of the find string replaced with the replace string. Punctuation in the find string is interpreted literally and not as a pattern.

Parameters

Argument Type Definition and Requirements

value

String

The source string to search through.

find

String

The string to be found in the value string.

replace

String

The new string that replaces the find string.

Returns

A new string which has all find strings replaced with the replace string.

Examples

The query below executes an array of independent ReplaceStr operations and returns the results in an array. The result array position matches the execution array position. The first operation takes a string "One Fish Two Fish" and replaces the string "Two" with the string "Blue". The resultant string "One Fish Blue Fish" is placed in the top position of the result array. The second operation takes the string "One Fish Two Fish" and replaces all instances of the string "Fish" with the string "CAT". The resultant string "One CAT Two CAT" is placed in the second position of the result array. The third operation takes the string "One Fis? Two Fish" and replaces all instances of the string "Fis?" with the word "Fish". The resultant String "One Fish Two Fish" is placed in the third position of the result array.

System.out.println(
  client.query(
    Arr(
       ReplaceStr("One Fish Two Fish", "Two", "Blue"),
       ReplaceStr("One Fish Two Fish", "Fish", "CAT"),
       ReplaceStr("One Fis? Two Fish", "Fis?", "Fish")
    )
  ).get());
["One Fish Blue Fish", "One CAT Two CAT", "One Fish Two Fish"]