This page explains how to use the array_index_of function in APL.
array_index_of
function in APL returns the zero-based index of the first occurrence of a specified value within an array. If the value isn’t found, the function returns -1
. Use this function when you need to identify the position of a specific item within an array, such as finding the location of an error code in a sequence of logs or pinpointing a particular value within telemetry data arrays.
Splunk SPL users
mvfind
function retrieves the position of an element within an array, similar to how array_index_of
operates in APL. However, note that APL uses a zero-based index for results, while SPL is one-based.ANSI SQL users
Name | Type | Required | Description |
---|---|---|---|
array | array | Yes | Input array to search. |
lookup_value | scalar | Yes | Scalar value to search for in the array. Accepted data types: long, integer, double, datetime, timespan, or string. |
start_index | number | No | The index where to start the search. A negative value offsets the starting search value from the end of the array by abs(start_index) steps. |
length | number | No | Number of values to examine. A value of -1 means unlimited length. |
occurrence | number | No | The number of the occurrence. By default 1 . |
array_index_of
returns the zero-based index of the first occurrence of the specified lookup_value
in array
. If lookup_value
doesn’t exist in the array, it returns -1
.
array_index_of
to find the position of a specific HTTP status code within an array of codes in your log analysis.Querystatus_array | index_500 |
---|---|
[“200”, “404”, “500”] | 2 |
status
codes and identifies the position of the first occurrence of the 500
status.