REMOVE_FIRST

Removes the first occurrence of the specified sub-text from text.

Syntax 

REMOVE_FIRST(text, text_to_remove)

Examples 

Example 1

Input

{
  "my_action": {
    "message": "The car carted carrots"
  }
}

Formula

REMOVE_FIRST(my_action.message, "car")

Output

"The  carted carrots"