FilterValues

Returns a text result containing only the values that were provided in filterValues, in the order they were originally entered in textToFilter.

Format

FilterValues ( textToFilter ; filterValues )

Parameters

textToFilter - any text expression or text field

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

Data type returned

text

Originated in version

7.0

Description

For a description of a list of values, see ValueCount function.

Each returned value ends with a carriage return, allowing lists to be easily concatenated.

Notes

If the filterValues parameter doesn’t have any values, an empty string is returned.
The FilterValues function is not case sensitive.

Example 1

FilterValues ( "Plaid¶Canvas¶Suitcase" ; "Plaid¶Canvas" ) returns Plaid¶Canvas¶.

Example 2

FilterValues ( ValueListItems ( "Database" ; "Sizes" ) ; "Medium¶Small" ) returns Small¶Medium¶ when a database file named Database has a value list Sizes that contains Small¶Medium¶Large.