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.
propercase(o, i, t)
||Original value, or question reference.
||Words to ignore or exclude from capitalisation such as and, the, of, etc.
||Terms after which to capitalise the next letter such as ‘ Mc’, ‘-’, etc.
The function below would render the text below as follows =propercase([q1.Surname], "and|the|of", "Mc|O'|Mc'|Mac")
|MCDONALD AND O'DONNELL
||McDonald and O'Donnell