Filemaker Pro 8.5 Educational Maintenance T3 TJ083LL/A User Manual

Product codes
TJ083LL/A
Page of 238
Chapter 12
  
|
  Text functions     165
Description
Returns a text result containing only the characters that were provided in filterValues, 
in the order that they were originally entered in textToFilter. If filterValues 
doesn’t have any characters, 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.
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 
Data type returned
text
Description
Returns text, converted to the CSS (Cascading Style Sheets) format, an Internet text 
format similar to 
. CSS supports more text formats than HTML, so CSS will 
represent what you have typed more accurately.