Quote()

Category: Logical

Syntax: Quote ( text )


Parameters:

textAny expression that resolves to a text string.

Data type returned: Text

Description:

The Quote() function returns the specified text string enclosed in quotation marks. To escape any special characters within the text string, such as quotation marks and double backslashes, place a backslash before them in the text string.

The Quote() function is used primarily in conjunction with the Evaluate() function, which can evaluate a dynamically generated formula. If the formula you are assembling contains a literal text string enclosed by quotation marks, or if it includes field contents that may potentially have quotation marks in it, then use the Quote() function to ensure that all internal quotation marks are escaped properly.

Examples:

If the FullName field contains the name Billy "Joe" Smith, then Quote (FullName) would return "Billy "Joe" Smith". The absence and presence of quotation marks here is deliberate; the quotation marks are part of the returned string.



: FileMaker Specifications

FileMaker 8 Product Line

Specifications and Storage Limits

Field Types and Import/Export Formats

: Calculation Functions

Working with Calculations Primer

Calculation Signatures

Calculation Functions

: Custom Functions

Custom Functions Primer

Useful Custom Functions

: Script Steps

Scripting Primer

Script Step Reference

: Quick Reference

FileMaker Error Codes

FileMaker Keyboard Shortcuts

FileMaker Network Ports

FileMaker Server Command Line Reference

FileMaker XML Reference

: Other Resources

Where to Go for More Information



FileMaker 8 Functions and Scripts Desk Reference
FileMaker 8 Functions and Scripts Desk Reference
ISBN: 0789735113
EAN: 2147483647
Year: 2004
Pages: 352

Flylib.com © 2008-2020.
If you may any questions please contact us: flylib@qtcs.net