indexOf

Description

Returns the position of the first occurrence of a substring within a string.

The index is zero-based. If the substring is not found, the function returns -1.

Syntax

Like many functions in DataPrime, indexOf supports two notations, function and method notation. These interchangeable forms allow flexibility in how you structure expressions.

indexOf(value: string, substring: string): number

(value: string).indexOf(substring: string): number

Arguments

Example

Extract a value from a key-value style string

Consider the following document:

{
    "msg": "result=Some value"
}

Use indexOf to find the position of = and then extract everything after it.

Example query

create index_of_value from (indexOf(msg, '='))

create index_of_value from (msg.indexOf('='))

Example output

With the index known, you can extract the substring:

create value from msg.substr(index_of_value)

Result:

{
    "msg": "result=Some value",
    "index_of_value": 6,
    "value": "Some value"
}