String manipulation

CONTAINSANY – Test if any strings are contained

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

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

Was this helpful?