Filemaker Pro 8.5 Advanced Maintenance TG761Z/A User Manual
Product codes
TG761Z/A
Chapter 12
|
Text functions 181
Quote
Format
Quote(text)
Parameter
text - any
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.
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
Replace
Format
Replace(text;start;numberOfCharacters;replacementText)
Parameters
text - any
start - any numeric expression or field containing a number representing the starting
position in text.
numberOfCharacters - any numeric expression or field containing a number
numberOfCharacters - any numeric expression or field containing a number
representing the number of characters to remove from text.
replacementText - any text expression or field containing the text to replace in the
original string.
Data type returned
text