Filemaker Pro 8.5 Advanced Maintenance TG761Z/A User Manual

Filter(textToFilter;filterText)

textToFilter - any 

 or text 

filterText - the characters to preserve in the specified text

text

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. 

Filter(“(408)555-1212”;“0123456789”) returns 

.

Filter(“AaBb”;“AB”) returns 

.

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 

 this calculation returns 

.

FilterValues(textToFilter; filterValues)

textToFilter - any 

 or text 

filterValues - values that you want to preserve in the specified text

See chapter 4, “Design functions” for information about literal text parameters.

text