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" )
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
: Custom Functions
Custom Functions Primer
Useful Custom Functions
: Script Steps
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