1.3.4.9.13 Match Transformation: Lower Case

The Lower Case transformation is a simple transformation that converts values to all lower case, enabling case insensitive clustering.

Use the Lower Case transformation where you want to use case insensitive clustering.

For example, when clustering an email address identifier, you may want to create cluster values using all lower case characters, as email addresses are not normally used in a case sensitive manner; that is, John.Smith@example.com is usually (but not always) the same address as john.smith@example.com. To ensure the two records are in the same cluster, the lower case transformation may be used.

Options

None

Example

In this example, the Lower Case transformation is used when creating clusters on the first few characters of an email address. Values are converted to all lower case before selecting a number of characters to use as the cluster.

Example transformations

The following table shows example transformations using the above configuration:

Table 1-85 Example Transformations for Lower Case

Value Transformed Value

John.Smith@example.com

john.smith@example.com

john.smith@example.com

john.smith@example.com

JAMES_LEWIS@HOTMAIL.COM

james_lewis@hotmail.com

james_lewis@hotmail.com

james_lewis@hotmail.com