Calculation Formulas

Back to Calculation Formulas Overview
Back to Functions Overview

Function "ReplaceText"

ReplaceText(arg, oldtext, newtext)

Function: Searches for all occurrences of "oldtext" in the given "arg" and replaces these occurrences with "newtext". If "arg" is a single text, then the replacement is performed in this text and the result is returned. If "arg" is a Text Set, then the replacement is performed individually on all texts in the set and the resulting set is returned.

Return-Type: Text or Text Set

Arguments:
arg - Type Text or Text Set: The text (or set of texts) to search in.
oldtext - Type Text: The text that shall be replaced.
newtext - Type text: The text that shall replace all occurrences of "oldtext".

Examples:
ReplaceText("abc def abc def", "abc", "xyz")