SUBSTITUTE Function: Difference between revisions
From Planfix
(Created page with "This function substitutes the value of the "new_text" argument in place of the value of the "old_text" argument in a string. The SUBSTITUTE function is used when you need to r...") |
No edit summary |
||
| Line 4: | Line 4: | ||
''Format:'' | ''Format:'' | ||
*'''SUBSTITUTE(text;old_text;new_text)''' | *'''SUBSTITUTE(text;old_text;new_text)''' | ||
Revision as of 03:44, 6 December 2019
This function substitutes the value of the "new_text" argument in place of the value of the "old_text" argument in a string. The SUBSTITUTE function is used when you need to replace a specific part of a string.
Format:
- SUBSTITUTE(text;old_text;new_text)
Examples:
SUBSTITUTE(A;"sales";"prices")
SUBSTITUTE(Template:Task.String field;"what";"where")