Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

ListFindAll

Use this function to search a list for occurrences specified in a second list and return the index of any matches.

Syntax:

ListFindAll(list, find)

where:

  • list is a variable of type NUM[], STRING[], or RANGE.
  • find is a variable of the same type as list that contains the values to search for in list.

Syntax example:

CREATE VARIABLE myList1[] as STRING

CREATE VARIABLE myList2[] as STRING

CREATE VARIABLE myList3[] as NUM

SET VARIABLE myList1 = "a|b|c|d|e|f"

SET VARIABLE myList2 = "b|a|e|g"

 

SET VARIABLE myList3 = ListFindAll(myList1,myList2)

//In this example, myList3 equals 1,2,5.

Published:

ListFindAll

Use this function to search a list for occurrences specified in a second list and return the index of any matches.

Syntax:

ListFindAll(list, find)

where:

  • list is a variable of type NUM[], STRING[], or RANGE.
  • find is a variable of the same type as list that contains the values to search for in list.

Syntax example:

CREATE VARIABLE myList1[] as STRING

CREATE VARIABLE myList2[] as STRING

CREATE VARIABLE myList3[] as NUM

SET VARIABLE myList1 = "a|b|c|d|e|f"

SET VARIABLE myList2 = "b|a|e|g"

 

SET VARIABLE myList3 = ListFindAll(myList1,myList2)

//In this example, myList3 equals 1,2,5.

For an optimal Community experience, Please view on Desktop