textToFilter - any text expression or text field

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

text

If filterValues doesn’t have any values, 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.

When the textToFilter or the filterValues parameter is a literal string, you must insert a paragraph character (¶) between each item in the string. To insert a carriage return character, click the ¶ button in the Specify Calculation dialog box.

The FilterValues function is not case-sensitive.

FilterValues(“Plaid¶Canvas¶Suitcase”;“Plaid¶Canvas”) returns

FilterValues(ValueListItems(“Database”;“Sizes”);“Medium¶Small”) returns

when a database file named Database has a value list Sizes that contains Small¶Medium¶Large.