FilterReturns from textToFilter only those characters specified in filterText, in the order they were originally entered in textToFilter.filterText - the characters to preserve in the specified textFileMaker Pro 7.0If filterText doesn’t have any characters, an empty string is returned. The Filter function is case-sensitive.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:Let(phone = filter(theField;“0123456789”);“(“ & left(phone;3) & “)” & middle(phone;4;3) & “-” & middle(phone;7;4))