Text Functions

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

Категории