© Mark Conway Munro 2017

Mark Conway Munro, Learn FileMaker Pro 16, https://doi.org/10.1007/978-1-4842-2863-0_13

13. Text Functions

Mark Conway Munro1 

(1)Lewisburg, Pennsylvania, USA

Text functions are used to analyze, convert, combine, extract, and create text strings.

Text Function Reference

FileMaker provides the following text functions:

  • Char

  • Code

  • Exact

  • Filter

  • FilterValues

  • Furigana

  • GetAsCSS

  • GetAsDate

  • GetAsNumber

  • GetAsSVG

  • GetAsText

  • GetAsTime

  • GetAsTimestamp

  • GetAsURLEncoded

  • GetValue

  • Hiragana

  • KanaHankaku

  • KanaZenkaku

  • KanjiNumeral

  • Katakana

  • Left

  • LeftValues

  • LeftWords

  • Length

  • Lower

  • Middle

  • MiddleValues

  • MiddleWords

  • NumToJText

  • PatternCount

  • Position

  • Proper

  • Quote

  • Replace

  • Right

  • RightValues

  • RightWords

  • RomanHankaku

  • Roman ...

Get Learn FileMaker Pro 16: The Comprehensive Guide to Building Custom Databases now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial