Category: Text

Syntax: GetAsText ( data )


dataAny field or expression that returns a number, date, time, timestamp, or container.

Data type returned: Text

Description: GetAsText() returns the text equivalent of data in any other data type. You can then manipulate the data as you would any other text string.

When applied to a container field that stores a reference to an object, GetAsText() returns the path to the container data. If the container data is embedded in the database, GetAsText() returns a question mark.

One frequent use of GetAsText() is to get the path and filename information for container data stored as a reference. You can then parse the path information and build links to other objects in the same location.

In most cases, you do not need to explicitly coerce number, date, and time data into text before performing text operations on the data. Text functions operate on numbers, dates, and times as if they were text strings, even if you don't wrap the data with GetAsText().




GetAsText (Get (CurrentDate))

Might return 3/8/2004.

: 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 © 2008-2020.
If you may any questions please contact us: