STR_REPLACE Function

Function Type

Predefined function

Syntax

STR_REPLACE( <oldString>, <newString>, <stringValue>, <integerMaxReplacements>)

Description

Replaces instances of a string in one field of data with another string, up to the maximum allowable number of replacements.

Argument

Description

<oldString>

String value to be replaced.

<newString>

String replacement value.

<stringValue>

String value having portions replaced.

<integerMaxReplacements>

Maximum number of replacements to allow.

Returns

String

Example

STR_REPLACE("abc","ABC","abc/xyz/abc/xyz/abc",2) returns "ABC/xyz/ABC/xyz/abc" -- two replacements

STR_REPLACE("TX","Texas",Source.Table1.Field1) returns "Texas" for all occurrences of "TX" in the source field, Field1.