String manipulation

CONTAINSALL – Test if all specified strings are contained

25 views June 1, 2018 February 10, 2019 admin 0

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

Was this helpful?