$mid(text,S,N)

Returns N characters starting at position S in text.

 

$mid(othello,3,4)  returns hell

 

If N is zero, it returns the number of characters from S to the end of the line.

 

You may also use negative numbers for S or N.

-------------------------------------------

$pos(text,string,N)

Returns a number indicating the position of the Nth occurrence of string in text.

 

$pos(hello there,e,1)  returns 2

$pos(hello there,e,2)  returns 9

$pos(hello there,a,1)  returns $null

 

If N is zero, it returns the number of times string appears in text.

 

Note: You can use $poscs() for a case-sensitive version.