SUBSTITUTEALL
Syntax
SUBSTITUTEALL(<string>; <search string>; <new string>)
Description
Substitutes new text for all occurrences of old text in a text string.
Examples
String | Search string | New string | SUBSTITUTEALL returns |
|---|---|---|---|
search | nomatch | replacement | search |
search | search | replacement | replacement |
search search | search | replacement | replacement replacement |