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) == ABC
- This formula scans the value of ProcessName for ho, so svchost and shopper would
meet the comparison.
SCAN(ProcessName) == ho
- 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