Match Transformation: Character Replace

1.3.3.9.2 Match Transformation: Character Replace

Character Replace is a simple transformation that replaces individual characters in a string attribute. This enables the standardization or normalization of characters matching a Reference Data map.

Inconsistent characters such as accented letters or variants on symbols (such as open and closed quotes) can mask otherwise similar data. Use Character Replace to replace all instances of the character in the Reference Data map with its replacement character.

The following table describes the configuration options:

Configuration Description

Configuration	Description
Options	You can configure these options: `Ignore Case?`: To enable the replacement of both upper and lower case forms of characters (where they exist). Type: Yes/No. Default: `No`. Transformation Map Reference Data: Maps a character to its replacement character. Type: Reference Data. Default: `*Standardize Accented Characters`.

Options

You can configure these options:

Ignore Case?: To enable the replacement of both upper and lower case forms of characters (where they exist). Type: Yes/No. Default: No.
Transformation Map Reference Data: Maps a character to its replacement character. Type: Reference Data. Default: *Standardize Accented Characters.

Example

In this example the Character Replace transformation is used to standardize accented letters in a First name attribute using the following transformation map Reference Data:

Table 1-73 Transformation Reference Data

Lookup	Map	Comment
É	E	E acute
È	E	E grave
ô	o	o circumflex

Example Transformations

The following table shows character replacements using the above configuration:

Table 1-74 Example Transformations

Value	Transformed Value
élise	elise
Aimée	Aimee
Marie-Élise	Marie-Elise
Cécile	Cecile

Note:

Upper case É is transformed to E and lower case é is transformed to e.