ListContainsNoCase

Determines the index of the first list element that contains a specified substring.

ListContainsNoCase( list, substring [, delimiters [, includeEmptyFields [, multiCharacterDelimiter ] ] ] )

Returns: Number

Argument Description Default
list
string, required

a string list

substring
string, required

the string to search in the list

delimiters
string, optional

Characters that separate list elements. The default value is comma.

Alias: delimiter

,

includeEmptyFields
boolean, optional

if set to true, empty values are included as well

false

multiCharacterDelimiter
boolean, optional

specifying whether the delimiters parameter specifies a multi-character delimiter. If this parameter is true, the delimiters parameter must specify a single delimiter consisting of multiple characters. This parameter enables the ListToArray function to convert a list such as the following to an array of color names: red:|orange:|yellow:|green:|blue:|indigo:|violet.

false

Examples

There are currently no examples for this function.

See also