Limitación de responsabilidad por el uso del Traductor Google. Haga clic aquí .
SCANSTR function
The SCANSTR function evaluates the position of one string value (value 1) within another string value (value 2).
Syntax
SCANSTR(value 1, value 2)
-
Example 1
SCANSTR("Ontario","Toronto, Ontario")
Returns a value of 10.
-
Example 2
SCANSTR("Alberta","Toronto, Ontario")
Returns a value of 0.
Database Filter Syntax
SCANSTR(DATABASE -> FIELD, string), OPERATORVALUE
If the SCANSTR function finds the matching string, it returns a value for the position of that string. Therefore, if the string exists in a field the value returned will NOT be 0. Therefore a filter,
-
Example
SCANSTR(GL->JE_DESC,"BUDGET")>0
Returns any journal with a description line that contains, and matches exactly, the text string "BUDGET". The IN function could be used in the same way.