You are here: Processor Library > Transformation > Proper Case

Proper Case

The Proper Case processor converts text attribute values to upper case for the first character of each word and to lower case for subsequent characters in the word.

Use

Use the Proper Case processor when you want to standardize the appearance of words, for instance names or addresses for a mail shot.

Configuration

Inputs

Any String or String Array type attributes that you wish to convert to Proper 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

Option	Type	Purpose	Default Value
Delimiters Reference Data	Reference Data	Lists delimiters to be used to define words.	None
Delimiters	Free text	Lists delimiters to be used to define words.	Space
Preserve mixed case	Yes/No	Determines whether or not to retain the case of a mixed case word - for example to retain the case of 'McCartney', rather than transform it to Mccartney. However, if MACDONALD (all upper case) was the input word, this would still be transformed to Macdonald.	No
Exceptions	Reference Data	Lists words not to be transformed into Proper Case. For instance connector words such as van, der, de, of are often not capitalized.	None
Ignore case when matching exceptions	Yes/No	Determines whether or not to ignore case when matching the Exceptions Reference Data.	No
Action on Exception	Selection (Convert to upper case / Convert to lower case / Leave case as it is)	What action should occur to the words listed as exceptions.	Leave case as it is

Outputs

Data attributes

Data attribute	Type	Purpose	Value
[Attribute Name].Proper	Derived	The proper case version of the attribute value.	The original attribute value, converted to proper case.

Flags

None

Execution

Execution Mode	Supported
Batch	Yes
Real time Monitoring	Yes
Real time Response	Yes

Results Browsing

The Proper Case transformer presents no summary statistics on its processing. In the data view, each input attribute is shown with its new derived proper case attribute to the right.

Output Filters

None

Example

Names of various capitalizations have been transformed with the following options:

Delimiters: '.- (Space, Apostrophe, Full stop and Hyphen)

Preserve mixed case words: Yes.

Exceptions: Reference data list including 'van' but not 'de' .

Ignore case when matching exceptions: Yes

Action on Exception: Convert to lower case.