Change Text Case

Sometimes you have text that has been entered into your system of record that has been entered in the wrong case. For example you have PEOPLES NAMES in upper case and you want to change it to Proper case.

Rule Type Format

lower(field name)

upper(field name)

Snippits

Lower Case

Converts a text string to lower case. All alphabetical characters in a field are lowercased.

Convert Text in Field

Rule Type = Calculated Output Field

Rule Attribute = lower(first_name) : FirstName

Convert Static Text

Rule Type = Calculated Output Field

Rule Attribute = lower(‘Robert’) : FirstName

Examples

  • Robert becomes robert

  • ROBERT becomes robert

  • Robert James Brown becomes robert james brown

Upper Case

Converts a text string to upper case. All alphabetical characters in a field are capitalised.

Convert Text in Field

Rule Type = Calculated Output Field

Rule Attribute = upper(first_name) : FirstName

Convert Static Text

Rule Type = Calculated Output Field

Rule Attribute = upper(‘Robert’) : FirstName

Examples

  • Robert becomes ROBERT

  • robert becomes ROBERT

  • Robert James Brown becomes ROBERT JAMES BROWN

Title Case

Converts a text string to title case. If the first character of any word in the field is an alphabetical character, it is capitalised, else the alphabetical character is left as lower case.

Convert Text in Field

Rule Type = Calculated Output Field

Rule Attribute = agiledata_functions.nlp(first_name,’toTitleCase’) : FirstName

Convert Static Text

Rule Type = Calculated Output Field

Rule Attribute = agiledata_functions.nlp(‘ROBERT’,’toTitleCase’) : FirstName

Examples

  • ROBERT becomes Robert

  • robert becomes Robert

  • ROBERT JAMES BROWN becomes Robert James Brown