Functions Reference

FILEMAKER FUNCTIONS REFERENCE 212
Exact(Upper(“McDonald”);Upper(“MCDONALD”)) returns 1 (True).
Exact(“John”;“John ”) returns 0 (False).
Exact(BillTo;ShipTo) returns 1 (True) when the value in BillTo is the same as the value in
ShipTo.
Exact(Recipient;Upper(Recipient)) returns 1 (True), when Recipient contains JOHNSON.
Exact(Country;“Spain”) returns 1 (True) when the Country field contains Spain.
Related topics
Contents
Functions reference (alphabetical list)
Filter
Purpose
Returns from textToFilter only those characters specified in filterText, in the order they
were originally entered in
textToFilter.
Format
Filter(textToFilter;filterText)
Parameters
textToFilter - any text expression or text field
filterText - the characters to preserve in the specified text
Data type returned
text
Originated in
FileMaker Pro 7.0
Description
If filterText doesn’t have any characters, an empty string is returned. The Filter function is
case-sensitive.
Examples
Filter(“[phone]”;“0123456789”) returns 4085551212.
Filter(“AaBb”;“AB”) returns AB.
The following example removes all text from the provided data, then formats the remaining numbers
in the preferred phone number formatting:
Let(phone = filter(theField;“0123456789”);“(“ & left(phone;3) & “)” &
middle(phone;4;3) & “-” & middle(phone;7;4))
If theField contains Work: 408.555.1212 this calculation returns [phone].