SUBSTITUTE Function

From Planfix
Revision as of 03:43, 6 December 2019 by SliZzzZ (talk | contribs) (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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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)
  • SUBSTITUTE(text;old_text;new_text)


Examples:

SUBSTITUTE(A;"sales";"prices")

SUBSTITUTE(Template:Task.String field;"what";"where")


Go To

Retrieved from "http://planfix.com/help/index.php?title=SUBSTITUTE_Function&oldid=5210"