Middle
Purpose
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
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