CONTAINSTRING
Usage
Use this function to check if searched text is contained in the full text
Category | Function | Type | Where to use | Argument statement |
---|---|---|---|---|
FUNCTION | SERVER ROW | COMPARISON | .VALUE |
Syntax
1 |
|
Arguments
Parameter_1
String where checking if Parameter_2 argument is contained: any column field value (#Storage_Name.Field_Name.VALUE
or .OLDVALUE
), constant, System Variables or function-returned value
Parameter_2
String to check in the Parameter_1 argument: any column field value (#Storage_Name.Field_Name.VALUE
or .OLDVALUE
), constant, System Variables or function-returned value
Note
The CONTAINSTRING is keysensitive
Return Value
Boolean (true or false)
Examples
Example 1
Formula
=CONTAINSTRING("Welcome to eLegere"; "eLegere")
Description
Check if the value eLegere is contained in the string Welcome to eLegere
Result
true
Example 2
Formula
=CONTAINSTRING(#Software.Description.VALUE; "eLegere")
Description
Check if the value eLegere is contained in the cell values of the field Description in the storage Software
Result
true or false