text.indexesOf

Description

Finds all occurrences of a substring within a string, returning an array of all matching positions. Optionally search within a specific range.

Syntax 

flex.text.indexesOf(string, substring, from, to)

Parameters

| Parameter | Type | Required | Description | |———–|——|———-|————-| | string | string | Yes | The string to search in | | substring | string | Yes | The substring to search for | | from | number | No | Starting position for search (default: 0) | | to | number | No | Ending position for search (default: -1, meaning end of string) |

Returns

Type: list of numbers

An array containing the zero-based indices of all occurrences of the substring. Returns an empty array if no matches are found. Returns null if the input string is null.

Examples

Example 1: Find All Occurrences 

RETURN flex.text.indexesOf('hello hello hello', 'hello') AS positions

Output:

positions
-----------
[0, 6, 12]

Example 2: Find Occurrences in Range 

RETURN flex.text.indexesOf('abcabcabc', 'abc', 1, 9) AS positions

Output:

positions
---------
[3, 6]

(Skips first ‘abc’ at position 0, finds those within range)

Example 3: Count Keyword Occurrences 

MATCH (d:Document)
WITH d, flex.text.indexesOf(d.content, 'important') AS occurrences
WHERE size(occurrences) > 2
RETURN d.title, size(occurrences) AS importanceScore
ORDER BY importanceScore DESC

Notes

  • Returns null if input string is null
  • Returns empty array if substring is not found
  • Uses zero-based indexing
  • The from parameter allows starting search from a specific position
  • The to parameter limits search to a specific range
  • Useful for counting occurrences or analyzing text patterns

See Also