Text Functions | Calculation Signatures

Text functions provide all the various text parsing tools within FileMaker, some specialized and some general.

Table 5.11. Text Functions
Syntax	Data Type Returned
`Exact ( originalText; comparisonText )`	Number
`Filter ( textToFilter; filterText )`	Text
`FilterValues ( textToFilter; filterValues )`	Text
`GetAsCSS ( text )`	Text
`GetAsDate ( text )`	Date
`GetAsNumber ( text )`	Number
`GetAsSVG ( text )`	Text
`GetAsText ( data )`	Text
`GetAsTime ( text )`	Time
`GetAsTimestamp ( text )`	Timestamp
`GetValue ( listOfValues; valueNumber )`	Text
`Hiragana ( text )`	Text (Japanese)
`KanaHankaku ( text )`	Text (Japanese)
`KanaZenkaku ( text )`	Text (Japanese)
`KanjiNumeral ( text )`	Text (Japanese)
`Katakana ( text )`	Text (Japanese)
`Left ( text; numberOfCharacters )`	Text
`LeftValues ( text; numberOfValues )`	Text
`LeftWords ( text; numberOfWords )`	Text
`Length ( text )`	Number
`Lower ( text )`	Text
`Middle ( text; startCharacter; numberOfCharacters )`	Text
`MiddleValues ( text; startingValue; numberOfValues )`	Text
`MiddleWords ( text; startingWord; numberOfWords )`	Text
`NumToJText ( number; separator; characterType )`	Text (Japanese)
`PatternCount ( text; searchString )`	Number
`Position ( text; searchString; start; occurrence )`	Number
`Proper ( text )`	Text
`Replace ( text; start; numberOfCharacters; replacementText )`	Text
`Right ( text; numberOfCharacters )`	Text
`RightValues ( text; numberOfValues )`	Text
`RightWords ( text; numberOfWords )`	Text
`RomanHankaku ( text )`	Text (Japanese)
`RomanZenkaku ( text )`	Text (Japanese)
`SerialIncrement ( text; incrementBy )`	Text
`Substitute ( text; searchString; replaceString )`	Text
`trim ( text )`	Text
`trimAll ( text; trimSpaces; trimType )`	Text
`Upper ( text )`	Text
`ValueCount ( text )`	Number
`WordCount ( text )`	Number