.. _text-change-case-snip:

================
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)

    initcap(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 = initcap(first_name) : FirstName


Convert Static Text
++++++++++++++++++++++

Rule Type = Calculated Output Field

Rule Attribute = initcap('Robert') : FirstName

Examples
+++++++++

* ROBERT becomes Robert

* robert becomes Robert

* ROBERT JAMES BROWN becomes Robert James Brown