Home > Reference > Functions reference > Text functions > Middle

Middle

Purpose 

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

Format 

Middle(text;start;numberOfCharacters)

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

Examples 

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

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

Middle(“abcdefghij”;5;2) returns ef.

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