Contains
Description
Allows for search of specific values or strings of text within a column's values.
Calculation Editor
Options
| Input Parameter Values | Input Values |
|---|---|
| Text to Find | Column or Literal (Required) |
| Input String is a | Filter: List of Values or Simple Text |
| Case Sensitivity | Case Sensitive or Ignore Case |
| Only Rollup If | Generic Criteria |
Input
| Input | Input Values | Required |
|---|---|---|
| Input 1 | Column or Literal | ✔ |
Remarks
- Input String is a "Filter: List of Values" will search a filter list of values (a list of values separated by semicolons) for a specific "Text to Find" value and return 1 only if it finds an entire field in the list that matches. Review example below.
- Case Sensitivity indicates whether capital and lowercase characters will be taken into account as a match or not.
Examples
Example 1
- Design > Calculations > Contains
- Inputs:
- Text to Find: Supplies
- Input String is a: Simple Text
- Case Sensitivity: Case Sensitive
- Input: Vendor Name (ex: ABC Supplies, Alphabet Homes)
- Output: ABC Supplies = 1 and Alphabet Homes = 0
Example 2
- Design > Calculations > Contains
- Inputs:
- Text to Find: 00004
- Input String is a: Filter: List of Values
- Case Sensitivity: Ignore Case
- Input: Document Numbers (ex: 00001;00004, 00001;00002;00003)
- Output: 00001;00004 = 1 and 00001;00002;00003 = 0
Note
If the above example had "Text to find" set to '4' instead of '00004', all resulting contains outputs for the example would result in 0 records because it is only checking for whole one to one matches inside the filter: list of values.