Applies to Infiniti v8.0 or later
 
Using specified characters, words and terms the propercase() function will capitalize text to suit the situation. Although it is possible to capitalize the first or each letter within a string of text the propercase() function caters for more complex examples such as MCDONALD and SMITH-JONES.

Usage

propercase(o, i, t)

Parameters

o Original value, or question reference.
i Words to ignore or exclude from capitalisation such as and, the, of, etc.
t Terms after which to capitalise the next letter such as ‘ Mc’, ‘-’, etc.

Example

The function below would render the text below as follows =propercase([q1.Surname], "and|the|of", "Mc|O'|Mc'|Mac")
MCDONALD McDonald
MCDONALD AND O'DONNELL McDonald and O'Donnell
MCDONALD-O'DONNELL McDonald-O'Donnell
MC'CARTHY Mc'Carthy
 

Related Articles

Keywords