Substitute Patterns of Text with a Label

To substitute text with a label, use the Replace calculation:

1. Click the Calculation Editor button on the main toolbar

2. Type in Replace under the Type of Calculation

3. On the Parameters tab enter values as follows:

Parameter	Effect
Source string	Column to use as the input for the text replace.
Default value	Column value or literal value to use if none of the text replace criteria matches.
Replace first string with second value	On the left-hand side, enter text or text patterns (you may use any valid filter to define what you want to replace). On the right-hand side, specify the value to replace with if the match occurs.