listValueCountNoCase

Counts instances of a specified value in a list. The search is
case-insensitive.

listValueCountNoCase(list, value [, delimiters]) → returns Numeric

Argument Reference for the listValueCountNoCase function

list

Required: Yes

value

Required: Yes

delimiters

Required: No
Default: ,
Values:
  • ,
  • |
  • ;
  • chr(9)
  • chr(10)
  • chr(13)

Examples sample code invoking the listValueCountNoCase function


Simple Example

Counts instances of 'foo' in the list, ignoring case

listValueCountNoCase("foo,bar,lorem,Foo,ipsum", "foo")

Expected Result: 2


Example with Custom Delimiter

Counts instances of 'foo' in the list with a custom delimiter, ignoring case

listValueCountNoCase("bar|Foo|lorem,ipsum|me|foo,something|foo|FOO", "foo", "|")

Expected Result: 3


Fork me on GitHub