Welcome to Catalog Tips
Search more than 200 articles to learn more about creating and automating your product catalogs
Tip: Start typing in the input box for immediate search results.
CONTAINSANY – Test if any strings are contained
Overview
This Custom Field returns TRUE if the first parameter contains any of the subsequent parameters.
Syntax
CONTAINSANY(FIELDSTR(Description),cyan,magenta)
| Element | Description |
|---|---|
| FIELDSTR(Description) | The string to search in. |
| Values | The string to search for. |
Example
CONTAINSANY(FIELDSTR(‘Colours’), ‘Blue’, ‘Dark’)
In the following list of colours, the above Custom Field query will return the following:
| Colours | CONTAINSANY(FIELDSTR(‘Colours’), ‘Blue’, ‘Dark’) |
| Green | FALSE |
| Dark Green | TRUE |
| Light Green | FALSE |
| Yellow | FALSE |
| Light Blue | TRUE |
| Royal Blue | TRUE |
| Dark Blue | TRUE |
| Orange | FALSE |
| Purple | FALSE |