Docs
CAN_SEARCH
Returns TRUE if the second text contains the first.
Unlike CAN_FIND, CAN_SEARCH is case-insensitive.
Usage
CAN_SEARCH(find_text, within_text, [start_position])
Parameters
| find_text |
(Required) The substring to search for within the text. |
| within_text |
(Required) The text string in which to search for the substring. |
| start_position |
The character’s position within the text where the search should begin. Defaults is 1, which starts from the beginning. |
Examples
More information
This is equivalent to using FIND and checking that the result is not NOTHING. So
NOT(ISNOTHING(SEARCH("/", serial_num))) is the same as CAN_SEARCH("/", serial_num).