Transformations
Replace Value
Use this to replace a specified value in a column. The settings are:
Which column to replace values in: Type in the name of the column that contains the values you want to replace.
Value to replace: Specify the value you want to replace. You can use regular expressions.
New value (optional): Specify the new value you want to take the place of the current value. If nothing is entered, it just deletes the value and leaves a blank.
Use regular expression (optional): Select this if you want to use regular expressions to identify the value to replace. Supports positive lookbehind.
