POS

POS(data, substring);

Position is location of the 1. Character in the substring. The returned position is 0-based - i.e. the first position in the string is 0, next is 1 etc.:

 

Example:

##POS(Name,'Pete')


Source Field: Paul Petersen

Returns: 5

If the substring cannot be found, a negative number (-1) is being returned.