Category: Text

Syntax: Middle ( text; startCharacter; numberOfCharacters )


textAny expression that resolves to a text string.

startCharacterAny expression that resolves to a numeric value.

numberOfCharactersAny expression that resolves to a numeric value.

Data type returned: Text


Returns a substring from the middle of the specified text parameter. The substring begins at startCharacter and extracts the numberOfCharacters characters following it. If the end of the string is encountered before the specified number of characters has been extracted, the function returns everything from the start position though the end of the string.

The Middle() function is often used in conjunction with other text functions as part of text parsing routines. For instance, if you had a field containing city, state, and ZIP data where the entries were consistently entered as "city, state zip", you could extract the state portion of the string with the following formula:

 Let ([commaPosition = Position(CSZ; ","; 1; 1); Middle
 (CSZ; commaPosition + 2; 2))




Middle ("hello world"; 3; 5)

Returns llo w.

Middle (FirstName; 2; 99999)

Returns everything except the first character of the first name.

: 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