Functions Reference

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(“[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].
FilterValues
Format
FilterValues(textToFilter; filterValues)
Parameters
textToFilter - any text expression or text field
filterValues - values that you want to preserve in the specified text
See chapter 4, “Design functions” for information about literal text parameters.
Data type returned
text
Description
Returns a text result containing only the characters that were provided in filterValues,
in the order that they were originally entered in textToFilter. If filterValues
doesn’t have any characters, an empty string is returned.
Values are text items separated by carriage returns. A value can be empty, a single
character, a word, a sentence, or a paragraph. When you press Enter or Return, you start
creating a new value. The last value will be recognized with or without a carriage return.