1.3.11.22 Lower Case

The Lower Case processor converts all input attribute values to lower case, and returns the converted value in a new attribute.

Use the Lower Case processor where you want to use validation rules that are not case sensitive, or for case standardization as part of data cleansing.

The following table describes the configuration options:

Configuration Description

Inputs

Specify any String or String Array type attributes that you want to convert to lower case. Number and Date attributes are not valid inputs.

If you input an Array attribute, the transformation will apply to all array elements, and an Array attribute will be output.

Options

None.

Outputs

Describes any data attribute or flag attribute outputs.

Data Attributes

The following data attributes are output:

  • [Attribute Name].Lower: the lower case version of the attribute value. Value is derived from the original attribute value, converted to lower case.

Flags

None.

The Lower Case processor presents no summary statistics on its processing.

In the Data view, each input attribute is shown with its new derived lower case attribute to the right.

Output Filters

None.

Example

In this example, the values in an Email address attribute are converted to all lower case:

EMAIL EMAIL.Lower

A.SHELBURNE@BTOPENWORLD.COM

a.shelburne@btopenworld.com

DAROBE@Tinyworld.co.uk

darobe@tinyworld.co.uk

k.smith@yahoo.co.uk

k.smith@yahoo.co.uk

N SHARP@BEEB.NET

n sharp@beeb.net