Functions Reference

Chapter 12
|
Text functions 175
Proper
Format
Proper(text)
Parameter
text - any text expression or text field
Data type returned
text
Description
Returns the first letter of each word in text as uppercase and all other letters as
lowercase.
Examples
Proper(“ABCD”) returns Abcd.
Proper(Name) returns Yumiko Kitagawa, when the Name field contains YUMIKO
KITAGAWA.
Quote
Format
Quote(text)
Parameter
text - any text expression or field
Data type returned
text
Description
Returns the text form of text enclosed in quotation marks. Special characters within
text are escaped appropriately. This function protects text from being evaluated by the
Evaluate function.
Examples
Quote(“hello”) returns “hello”
Quote(“abc\¶”) returns “abc\¶”
Quote(“say \”hello\” fred”) returns “say \”hello\” fred”
Evaluate(Quote(“1 + 2”)) returns 1 + 2
Evaluate(“1 + 2&” & Quote(“ - 1 + 2”)) returns 3 - 1 + 2