• Text Functions
  • ANSI Character 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
  • Text Functions
  • 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