listValueCountNoCase

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

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

listValueCountNoCase Argument Reference

list String
Required

value String
Required

delimiters String
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