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

ListFindFirst

Use this function to search a list for the first occurrence of a specified value and return the index of the match.

Syntax

Copy

Syntax

ListFindFirst(list, find)         

where:

  • list is a variable of type NUM[], STRING[], or RANGE.
  • find is the value to search for or a variable of the same type as list that contains the values to search for in list. If you are searching for a string value, you must enclose it in double quotation marks.
Copy

Syntax example

CREATE VARIABLE myList1[] AS STRING
CREATE VARIABLE nResult AS NUM
CREATE VARIABLE bResult AS NUM
CREATE VARIABLE sValue AS STRING
  
SET VARIABLE myList1 = "a|b|c|d|e|f"
SET VARIABLE sValue = "d"
SET VARIABLE nResult = ListFindFirst(myList1, sValue)
SET VARIABLE bResult = ListFindFirst(myList1, "b")    

// In this example, nResult equals 4 and bResult equals 2.        

Published:

ListFindFirst

Use this function to search a list for the first occurrence of a specified value and return the index of the match.

Syntax

Copy

Syntax

ListFindFirst(list, find)         

where:

  • list is a variable of type NUM[], STRING[], or RANGE.
  • find is the value to search for or a variable of the same type as list that contains the values to search for in list. If you are searching for a string value, you must enclose it in double quotation marks.
Copy

Syntax example

CREATE VARIABLE myList1[] AS STRING
CREATE VARIABLE nResult AS NUM
CREATE VARIABLE bResult AS NUM
CREATE VARIABLE sValue AS STRING
  
SET VARIABLE myList1 = "a|b|c|d|e|f"
SET VARIABLE sValue = "d"
SET VARIABLE nResult = ListFindFirst(myList1, sValue)
SET VARIABLE bResult = ListFindFirst(myList1, "b")    

// In this example, nResult equals 4 and bResult equals 2.        

For an optimal Community experience, Please view on Desktop