Functions Reference

Chapter 12
|
Text functions 159
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.
GetAsCSS
Format
GetAsCSS(text)
Parameter
text - any text expression
or text field
Data type returned
text
Description
Returns text, converted to the CSS (Cascading Style Sheets) format, an Internet text
format similar to HTML
. CSS supports more text formats than HTML, so CSS will
represent what you have typed more accurately.
Note The GetAsCSS function does not return formats that are set in the Conditional
Formatting dialog box.