Docs
CAN_FIND
Returns TRUE if the second text contains the first.
Unlike CAN_SEARCH, CAN_FIND is case-sensitive.
Usage
CAN_FIND(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(FIND("/", serial_num))) is the same as CAN_FIND("/", serial_num).