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.

Copy

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.
Copy

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.

Copy

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.
Copy

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