Extracting a name from string text field (Delimiters)

[Debug44]

I need to extract the proper name on a field where the string data looks like below...
(Using Crystal 10)

Example
{unit.operator} returns
"cn= Alan Mathis/OU=Waco/O=WEB" or
"cn= Anthony Winkelmann/OU=Waco/O=WEB"

I need it to extract the proper name.
Preceding the name is always "cn= " and is always followed by "/'.
Tried the mid and trim functions and even the split function.
Split returns the error message "a formula can not result in an array"

Any help would be appreciated...Thanks
Bart

 

[IanWaterman]

instr({unit.operator},"/") returns position of the /

use mid

mid({unit.operator},4, (instr({unit.operator},"/")-1))

Ian

 

[Debug44]

Worked Great...thanks a million for the fast reply, Ian.

Bart