Working with Data Models › Macro Toolbox › Miscellaneous Macros › %Substitute

%Substitute

Substitutes given pattern (second argument) with a given substitute string (third argument) in a given string (first argument).

Syntax

%Substitute(<value>,<pattern>,<substitute>)

Syntax Example

%Substitute(%ColName, movie,MV)

Expansion

MV_copy_number

Usage

Classified as Miscellaneous macro.