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