MIDDLE

MIDDLE(data, substring);

Using this function, your program will return the middle string according to what you specify.

 

Example:

The field value is  'One Two Three'.

MIDDLE(data, ' ');
Returns 'Two'.

MIDDLE(data, 'One');
Returns '0' (null).

MIDDLE(data, 'T');
Returns  'wo ' (with a blank at the end).