• Text Functions
  • Text Functions
  • CLNTDIR function
  • CLNTNAME function
  • CURRENCY function
  • DOCPATH function
  • IN function
  • LEFT function
  • LENGTH function
  • LOWER function
  • LTRIM function
  • MID function
  • MKSTR function
  • PRGDIR function
  • RIGHT function
  • SCANSTR function
  • SPACE function
  • STR function
  • SUBSTR function
  • TITLE function
  • TOKEN function
  • TOKENSUB function
  • TRIM function
  • TRIMRTF function
  • UPPER function
  • XRND function
  • XWKS function

TITLE Function

The TITLE function returns a string to normalized case.

Syntax

TITLE(expression)

Example

TITLE("BRITISH COLUMBIA")

Displays the string "British Columbia".

CaseView's default behavior is to only capitalize letters that follow a space. An optional capitalization argument may be added to force capitalization of letters following any character other than another letter, a number, or a single quote.

Syntax

TITLE (expression, capitalization)

Example

TITLE("retained earnings (deficit)",0) will display as Retained Earnings (deficit)

TITLE("retained earnings (deficit)",1) will display as Retained Earnings (Deficit).

Note: A single quote (') is excluded so TITLE("bob's pizza") will display correctly as Bob's Pizza.

Related Topics

• Text Functions