PROPER

Proper returns the value in a given string with the first character of each word converted to upper case.

PROPER( <field_name or string>)

  • field name or string: Field or string to be used

Example: create a field at the Household level to convert the State field to proper case.

PROPER([Household.State])

  • Returns Colorado for an input of colorado

  • Returns Colorado for an input of COLORADO

  • Returns New Jersey for an input of new jersey