MID

This function retains a specified number of characters from a string and removes the remaining characters.

MID(String , Start , Length)


PARAMETERS

String

The string expression from which the characters will be returned.

Start

Character position in string at which the part to be taken begins

Length

Number of characters to return

EXAMPLE:
Retrieve the 5th through 10th characters of the value contained in TEXT1 and store the result in TEXT2.

SETVALUE(~TEXT2~//MID(~TEXT1~,5,6))