Chapter 13: Text Functions

Chapter 13 contains a complete reference guide to using FileMaker’s built in Text Functions.


The following functions are discussed in this chapter:

  • Text Function Reference
  • Char
  • Code
  • Exact
  • Filter
  • FilterValues
  • GetAsCSS
  • GetAsDate
  • GetAsNumber
  • GetAsSVG
  • GetAsText
  • GetAsTime
  • GetAsTimestamp
  • GetAsURLEncoded
  • GetValue
  • Left
  • LeftValues
  • LeftWords
  • Length
  • Lower
  • Middle
  • MiddleValues
  • MiddleWords
  • NumToJText
  • PatternCount
  • Position
  • Proper
  • Quote
  • Replace
  • Right
  • RightValues
  • RightWords
  • Serial Increment
  • SortValues
  • Substitute
  • Trim
  • TrimAll
  • UniqueValues
  • Upper
  • ValueCount
  • WordCount