Category: Text

Syntax: Filter ( textToFilter; filterText )


textToFilterAny expression that resolves to a text string.

filterTextThe characters to preserve in the specified text.

Data type returned: Text


Strips from textToFilter all the characters not explicitly listed in filterText. All remaining characters are returned in the order in which they exist in textToFilter, including duplicates. If filterText doesn't have any characters, an empty string is returned, as opposed to a question mark. The Filter() function is case sensitive.

The Filter() function is frequently used to ensure that users have entered valid data into a field. The textToFilter parameter should contain any valid characters; the order of the characters within textToFilter isn't important.




Filter ( "ab123"; "abc" )

Returns ab.

Filter ( PhoneNumber; "0123456789" )

Would strip any non-numeric characters from the PhoneNumber field.

: 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: