Type
Text Function

Purpose
The midc function extracts a specified number of characters from the middle of a text value.

Syntax
midc( TEXT VALUE, m, n)
?where;
m is the starting position in the text value and
n is the number of characters to extract.

Returns
A text value n characters in length.

Usage
midc(FIELDNAME, m, n) returns n characters beginning at character position m (inclusive). Spaces and punctuation symbols are included.
Examples
midc( "DataEase" , 4, 3)
Returns: aEa

midc( "Club ParaDEASE" , 6, 3)
Returns: Par

midc( LAST NAME, 4, 2)
Returns: Two characters beginning at the fourth character position in the LAST NAME field for every record that is processed. If a record contains the value Birnbaum in the LAST NAME field, the function returns nb.