Help

FILEMAKER PRO HELP 891
Originated in
FileMaker Pro 7.0
Description
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
GetAsCSS
Purpose
Returns text converted to the CSS (Cascading Style Sheets) format.
Format
GetAsCSS(text)
Parameters
text - any text expression or text field