Documentation

strings.substring() function

The strings.substring() function returns a substring based on start and end parameters. These parameters are represent indices of UTF code points in the string.

Output data type: String

import "strings"

strings.substring(v: "influx", start: 0, end: 3)

// returns "infl"

Parameters

v

The string value to search.

Data type: String

start

The starting index of the substring.

Data type: Integer

end

The ending index of the substring.

Data type: Integer

Examples

Store the first four characters of a string
import "strings"

data
  |> map(fn: (r) => ({
      r with
      abbr: strings.substring(v: r.name, start: 0, end: 3)
    })
  )

New! Cloud or OSS?

InfluxDB OSS 2.0 now generally available!

InfluxDB OSS 2.0 is now generally available and ready for production use. See the InfluxDB OSS 2.0 release notes.

For information about upgrading to InfluxDB OSS 2.0, see: