@ReplaceAll

@REPLACEALL replaces the part of a string that contains the expression with a replacement string.

DTP Type:

@REPLACEALL cab be assigned to a DTP of type string, password, member, members, dimension, or dimensions.

Syntax:

@REPLACEALL(String,Regular Expression,replaceString)

Parameters:

Parameter	Description
String	Design-time prompt or text
Regular Expression	Design-time prompt or text
replaceString	Design-time prompt or text

Example:

[ReplaceAll_Str]=@REPLACEALL([String1],[Rep_String],[new_String])

Where:

• [ReplaceAll_Str] is a a DPT of type string that is not a checked prompt.

• [String1] is a DTP of type string that is a checked prompt.

• [Rep_String] is a DTP of type string that is a checked prompt.

• [new_String] is a DTP of type string that is a checked prompt.

Assume that the parameters are as follows:

• String: "This is a test of a testing string"

• Regular Expression: "Test"

• Replace String "XYZ"

In this example, [ReplaceAll_Str] returns: "This is a XYZ of a XYZing string for one XYZ and two XYZ". It replaced with "test with XYZ. "