SUBSTRING
Description
Extracts a string between two indexes of the given string (the second index is not inclusive)
Syntax
SUBSTRING (text, start, end)
Parameters
Attribute of the Plain Text type or string constant or calculation producing text and two indexes
Returns
Text: the part of the text between the two indexes (end index not included).
Example
IF SUBSTRING (Account.Name, 0, 4) = 'John' THEN ...