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



: FileMaker Specifications

FileMaker 8 Product Line

Specifications and Storage Limits

Field Types and Import/Export Formats

: Calculation Functions

Working with Calculations Primer

Calculation Signatures

Calculation Functions

: Custom Functions

Custom Functions Primer

Useful Custom Functions

: Script Steps

Scripting Primer

Script Step Reference

: Quick Reference

FileMaker Error Codes

FileMaker Keyboard Shortcuts

FileMaker Network Ports

FileMaker Server Command Line Reference

FileMaker XML Reference

: Other Resources

Where to Go for More Information



FileMaker 8 Functions and Scripts Desk Reference
FileMaker 8 Functions and Scripts Desk Reference
ISBN: 0789735113
EAN: 2147483647
Year: 2004
Pages: 352

Flylib.com © 2008-2020.
If you may any questions please contact us: flylib@qtcs.net