Reference > Functions reference > Text functions > Middle
 

Middle

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

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

Description 

If start ≤ 1, then this function is evaluated as if start = 1. If start is greater than the length of text, this function returns nothing.

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