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.

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.