SUBSTITUTE Function: Difference between revisions

From Planfix
Jump to: navigation, search
No edit summary
No edit summary
 
(2 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 11: 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")


Go To