replaceThis Analytics Edge wizard lets you replace text in selected columns. It supports the usual * and ? wildcard matching.

It is usually used to clean up data for reporting purposes, and you can use this wizard repeatedly to perform a series of replacements.

Pick Columns – select the columns to be modified either by column letter position or By Name.

Replace matching characters – this is the simplest form of the function. Characters you enter in the Find Text field will be replaced with characters in the Replace With field. It will replace characters anywhere in the cell value, even if they occur more than once.

Replace entire cell – this option allows you to use a wildcard match (* for any number of characters, ? for a single character), and only cells that match the whole cell value will be changed. If you use a * in the Replace With field, the original cell value will be inserted (useful for adding text before or after the original cell value).

Use regular expressions – you can also use a regular expression match and replacement. This is an advanced option, and knowledge of regular expressions in needed.

Ignore case – check this option to match both upper and lower case letters.