Avis de non-responsabilité relative à l’utilisation de Google Traduction. Cliquez ici.
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.