Filemaker TH325Z/A Datový list stáhnout pdf (Strana 181)

Chapter 12

Text functions 181

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

Replace

Format

Replace(text;start;numberOfCharacters;replacementText)

Parameters

text - any text expression

or text field

start - any numeric expression or field containing a number representing the starting

position in text.

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

1 2 ... 176 177 178 179 180 181 182 183 184 185 186 ... 237 238

Žádné komentáře

Filemaker TH325Z/A Datový list Strana 181