SCAN
SCAN returns a number indicating the starting
location of the first occurrence of a specified substring within a
given string.
This is a TM1® rules function, valid in both TM1 rules and TurboIntegrator processes.
If the substring does not occur in the given string, the function returns zero.
Syntax
SCAN(substring, string)
Argument |
Description |
---|---|
substring |
The substring you are trying to locate. |
string |
The string within which you are searching for the substring. |
Example
SCAN('scribe', 'described') returns 3.