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 |