SCAN: Scan for string within a string
Use the SCAN formula function in a situation, query, view filter or table view threshold to scan the data sample for the specified text or time stamp.
Scan
for string within a string- Searches for the value or partial value occurring anywhere in the text or time stamp returned by the attribute. The == Equal relational operator is valid; all other operators return invalid or unwanted results.
- Text examples
- This formula scans the value of Owner for CD anywhere in
the text. For example, an owner named ABCDEF would meet the
comparison.
SCAN(Owner) == CD - Time example
- This formula scans the timestamp for a value of 07/08. A date
of 07/08/10 would meet the comparison as would 12/07/08.
SCAN(Timestamp) == 07/08 - Wildcards
- You can use an * asterisk wildcard to begin or end the attribute value. You can also use the ? question mark wildcard for a single character at that position.