FilterValues function

Contents > Functions reference (alphabetical list) > Text functions > FilterValues function

FilterValues function

Format


FilterValues(textToFilter; filterValues)

Parameters

textToFilter - any text expression or text field

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

Important See Design functions for information about literal text parameters.

Data type returned

text

Description

Returns a text result containing only the values that were provided in filterValues, in the order that they were originally entered in textToFilter. 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.

Examples

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

Plaid

Canvas

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.

Related topics

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas

Contents > Functions reference (alphabetical list) > Text functions > FilterValues function