SUBSTITUTEFIRST
Syntax
SUBSTITUTEFIRST(<string>; <search string>; <new string>)
Description
Substitutes new text for the first occurrence of the old text in a text string.
Examples
String | Search string | New string | SUBSTITUTEFIRST returns |
|---|---|---|---|
search | nomatch | replacement | search |
search | search | replacement | replacement |
search search | search | replacement | replacement search |