[PRETTIFY], [LOWER], & [UPPER] - Changing Text Case

Sometimes, the letter case of data from an input field (e.g., an HR system) does not match the desired format for the output value. This can happen if data entry is inconsistent. The LOWER, UPPER, and PRETTIFY functions can be used to standardize the text case of an attribute.

Syntaxes

[LOWER] - Convert to Lowercase

This function converts all characters in a text string to lowercase.

• Syntax: [LOWER;Text]

Example:

• Input [DisplayName]: Jan-peder Olsen

• Expression: [LOWER;[displayname]]

• Output: jan-peder olsen

[UPPER] - Convert to Uppercase

This function converts all characters in a text string to uppercase.

• Syntax: [UPPER;Text]

Example:

• Input [DisplayName]: Jan-peder Olsen

• Expression: [UPPER;[displayname]]

• Output: JAN PEDER OLSEN

[PRETTIFY] - Capitalize First Letters (Title Case)

This function converts the text so that the first letter of each word is capitalized. This also works for names that are separated by a hyphen.

• Syntax: [PRETTIFY;Text]

Example:

• Input [DisplayName]: jan-peder olsen

• Expression: [PRETTIFY;[displayname]]

• Output: Jan-Peder Olsen