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.

< All Topics
Print

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

See also

CONTAINSALL

FINDFIELDCONTAINING

Table of Contents