Functions Reference

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.
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.
Example
GetAsCSS(text) returns the example result shown below when the field text contains
the word “Frank” and the word Frank has the following text attributes: Font = Helvetica,
Font Size = 12 points, Font Color = red, Font Style = bold.
Example result:
<SPAN STYLE = “font-family: ‘Helvetica’;font-size: 12px;color:
#FF0000;font-weight: bold;text-align: left;”>Frank</SPAN>