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