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

CONTAINSALL – Test if all specified strings are contained

Overview

This Custom Field  searches for a number of specified strings within a string. Returns TRUE if the first parameter contains all of the subsequent parameters.

Syntax

CONTAINSALL(FIELDSTR(Description),cyan,magenta)

Element Description
FIELDSTR(Description) The string to search in.
Values The string to search for.

Example

CONTAINSALL(FIELDSTR(‘Colours’), ‘Blue’, ‘Dark’)

In the following list of colours, the above Custom Field query will return the following:

Colours CONTAINSALL(FIELDSTR(‘Colours’), ‘Blue’, ‘Dark’)
Green FALSE
Dark Green FALSE
Light Green FALSE
Yellow FALSE
Light Blue FALSE
Royal Blue FALSE
Dark Blue TRUE
Orange FALSE
Purple FALSE

See also

CONTAINSANY

FINDFIELDCONTAINING

Table of Contents