TRANSFORMER
FIND
FIND is a calculator function that searches for a substring in a string. If the substring is found a number representing its starting position in the string is returned; if it is not found "-1" is returned.
The first character in a string always has position '0'.
Choose a field that is to contain the result in the Result Field drop-down list at the top, or create one by entering a new name.
Syntax
FIND(<text>,<search text>)
where <text> is the name of the field where you are looking and <search text> is the text you are looking for, enclosed in double quotation marks " ".
FIND is not case sensitive.
Use
Use FIND to locate records containing a specific (alphanumeric) value,
Example:
To find all names containing "John":
FIND(${Name},"John")
