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.