SUBSTITUTEFIRST
- Juliane Wetzel
- Konsta Danyliuk (Deactivated)
Owned by Juliane Wetzel
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 |