InfluxDB Docs

strings.compare() function

The strings.compare() function compares the lexicographical order of two strings.

Output data type: Integer

import "strings"

strings.compare(v: "a", t: "b")

// returns -1

Return values

ComparisonReturn value
v < t-1
v == t0
v > t1

Parameters

v

The string value to compare.

Data type: String

t

The string value to compare against.

Data type: String

Examples

Compare the lexicographical order of column values
import "strings"

data
  |> map(fn: (r) => ({
      r with
      _value: strings.compare(v: r.tag1, t: r.tag2)
    })
  )