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 |
||
| (4 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
{{#seo: | |||
|title=SUBSTITUTE Function | |||
|titlemode=append | |||
|keywords=planfix, function, SUBSTITUTE, substitute | |||
|description= SUBSTITUTE Function | |||
}} | |||
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. | 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. | ||
| Line 4: | Line 10: | ||
''Format:'' | ''Format:'' | ||
*'''SUBSTITUTE(text;old_text;new_text)''' | *'''SUBSTITUTE(text;old_text;new_text)''' | ||
| Line 12: | Line 17: | ||
SUBSTITUTE(A;"sales";"prices") | SUBSTITUTE(A;"sales";"prices") | ||
SUBSTITUTE({{Task.String field}};"what";"where") | SUBSTITUTE(<nowiki>{{Task.String field}}</nowiki>;"what";"where") | ||
Latest revision as of 06:59, 10 May 2024
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({{Task.String field}};"what";"where")