• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part V: Appendices > Functions

Appendix B. Functions

Here’s an all-in-one-place listing of FileMaker’s various functions, organized by type. Before digging into these tables, be sure you understand formulas and how to use expressions, constants, and operators. If you don’t, these tables won’t make much sense. For more information, see Defining Fields on page 99.

Table . Text Functions
SYNTAXDEFINITION
Exact (original text, comparison text)Returns a comparison of original text and comparison text in two text strings
Exact (original container, comparison container)Returns a comparison of original container and comparison container in two container fields
Left (text, number)Returns the specified number of characters in the supplied text, counting from the left
LeftWords (text, number of words)Returns a text result containing the specified number of words in the supplied text, counting from the left
Length (text)Returns the number or characters of text, including all spaces, numbers, and special characters
Lower (text)Converts all letters in the given text to lowercase
Middle (text, start, size)Returns characters from the supplied text, counting from start through number of characters in size
MiddleWords (text, starting word, number of words)Returns the middle words from the supplied text, from starting word through the number of words
PatternCount (text, search string)Returns the number of occurrences of the search string in text
Position (text, search string, start, occurrence)Scans the supplied text from start for the nth occurrence of a search string
Proper (text)Converts first letter in each word of text to uppercase and rest to lowercase
Replace (text, start, size, replacement text)Substitutes a series of characters for others in a string
Right (text, number)Returns the specified number of characters in the supplied text, counting from the right
RightWords (text, number of words)Returns a text result containing the specified number of words in the supplied text, counting from the right
Substitute (text, search string, replace string)Substitutes every occurrence of a specified set of characters in a text string with another set of characters you specify, and returns the revised text string
TextToDate (text)Returns the date equivalent of the supplied text, for use with formulas involving dates or date-oriented functions
TextToNum (text)Returns the numeric equivalent of the supplied text, for use with formulas involving numbers or numeric functions
TextToTime (text)Returns the time equivalent of the supplied text, for use with formulas involving time or time-oriented functions
Trim (text)Returns the supplied text, stripped of all leading and trailing spaces
Upper (text)Converts all letters in the given text to uppercase
WordCount (text)Returns a count of the total number of words in the given text



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint