1.3.11.45 Upper Case

The Upper Case processor converts text attribute values to upper case, and returns the converted value in a new attribute.

Use the Upper 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 upper case. Number and Date attributes are not valid inputs.

Note that 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:

  • Upper: the original attribute value, converted to upper case.

Flags

None.

The Upper Case transformer presents no summary statistics on its processing.

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

Output Filters

None.

Example

In this example, Upper Case is used at the beginning of a process to convert all String attributes to upper case for further processing:

TITLE TITLE.Upper NAME NAME.Upper

Ms

MS

Lynda BAINBRIDGE

LYNDA BAINBRIDGE

Null

Null

William BENDALL

WILLIAM BENDALL

Ms

MS

Karen SMITH

KAREN SMITH

Miss

MISS

Patricia VINER

PATRICIA VINER

Mr

MR

Colin WILLIAMS

COLIN WILLIAMS

Mr

MR

Ian PATNICK

IAN PATNICK

Ms

MS

Robera REYNOLDS

ROBERTA REYNOLDS

Miss

MISS

Winifride ROTHER

WINIFRIDE ROTHER