Middle

Extracts the specified numberOfCharacters from text, starting at the specified character position.

Format 

Parameters 

text - any text expression or text field

start - any numeric expression or field containing a number

numberOfCharacters - any numeric expression or field containing a number

Data type returned 

text

Originated in 

FileMaker Pro 6.0 or earlier

Example 1 

Middle ( "(408)555-9054" ; 2 ; 3 ) returns 408.

Example 2 

Middle ( PhoneNumber ; 2 ; 3 ) returns 408 when the PhoneNumber field contains (408) 555-9054.

Example 3 

Middle ("abcdefghij" ; 5 ; 2 ) returns ef.

Example 4 

Middle ( Name ; Position ( Name ; " " ; 1 ; 1 ) + 1 ; 3 ) returns Smi, when the text field Name contains John Smith.

Related topics 

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas