Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference PROPERCASE
Functions and Expressions Reference Guide
165
Uses
PRESENT is commonly used with the IF function in a map rule to provide
conditional logic. For example, if the object is present, do this; otherwise, do
something else.
Similarly,
PRESENT is commonly used with the WHEN function in component
rules to provide conditional validation logic.
Related Functions
ABSENT, IF, WHEN
PROPERCASE
The PROPERCASE function converts each "word" in a string, such that the first
alphabetic character is uppercase and the remaining alphabetic characters are
lowercase.
Syntax
PROPERCASE (single-text-item-expression)
Meaning
PROPERCASE (text_item_to_convert)
Returns
This function returns a single-text-item.
PROPERCASE views the text string as containing a series of "words" where the
delimiter between words is the space character. For each "word" in
text_item_to_convert,
PROPERCASE converts the first alphabetic character (for
example, A-Z and a-z) found to uppercase and all other characters are
converted to lowercase.
Examples
PROPERCASE ("sallY jo BRADLEY") returns Sally Jo Bradley
PROPERCASE ("One AND only 1one.") returns One And Only 1One.