Filemaker Pro 8.5 DE CD Box 5pk TH328D/A Manual Do Utilizador
Códigos do produto
TH328D/A
164 FileMaker Functions Reference
Filter
Format
Filter(textToFilter;filterText)
Parameters
textToFilter - any
or text
filterText - the characters to preserve in the specified text
Data type returned
text
Description
Returns from textToFilter only those characters specified in filterText, in the
order that they were originally entered in textToFilter. If filterText doesn’t have
any characters, an empty string is returned. The Filter function is case-sensitive.
Examples
Filter(“(408)555-1212”;“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:
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
“)” & middle(phone;4;3) & “-” & middle(phone;7;4))
If theField contains
Work: 408.555.1212
this calculation returns
(408)555-1212
.
FilterValues
Format
FilterValues(textToFilter; filterValues)
Parameters
textToFilter - any
or text
filterValues - values that you want to preserve in the specified text
Important
See chapter 4, “Design functions” for information about literal text parameters.
Data type returned
text