Text Functions
Text functions provide all the various text parsing tools within FileMaker, some specialized and some general.
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 |