REPLACE

Replaces every occurrence of the search text with the replacement text.

Syntax 

REPLACE(text, search, replace_with)

Examples 

Example 1

Input

{
  "my_action": {
    "message": "We will build what we need"
  }
}

Formula

REPLACE(my_action.message, "we", "I")

Output

"I will build what I need"