Determines the index of the first list element that contains a specified substring. Returns the index of the first list element that contains substring. If not found, returns zero.

string.listContains( list, substring [, delimiters [, includeEmptyFields [, multiCharacterDelimiter ] ] ] )

Returns: Number

Argument Description
string, required

a string list

string, required

the string to search in the list

string, optional

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

boolean, optional

if set to true, empty values are included as well

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.


There are currently no examples for this function

See also