REPLACE_FIRST

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

Syntax 

REPLACE_FIRST(text, search, replace_with)

Examples 

Example 1

Input

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

Formula

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

Output

"I will build what we need"
Was this helpful?