2.5 KiB
2.5 KiB
title | description | menu | weight | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
strings.compare() function | `strings.compare()` compares the lexicographical order of two strings. |
|
101 |
strings.compare()
compares the lexicographical order of two strings.
Return values
Comparison | Return value |
---|---|
v < t | -1 |
v == t | 0 |
v > t | 1 |
Function type signature
(t: string, v: string) => int
{{% caption %}} For more information, see Function type signatures. {{% /caption %}}
Parameters
v
({{< req >}}) String value to compare.
t
({{< req >}}) String value to compare against.
Examples
Compare the lexicographical order of column values
import "strings"
data
|> map(fn: (r) => ({r with same: strings.compare(v: r.string1, t: r.string2)}))
{{< expand-wrapper >}} {{% expand "View example input and output" %}}
Input data
time | string1 | string2 |
---|---|---|
2022-01-01T00:00:00Z | RJqcVGNlcJ | rjQCvGNLCj |
2022-01-01T00:01:00Z | unfbcNAXUA | hBumdSljCQ |
2022-01-01T00:02:00Z | ITcHyLZuqu | ITcHyLZuqu |
2022-01-01T00:03:00Z | HyXdjvrjgp | hyxDJvrJGP |
2022-01-01T00:04:00Z | SVepvUBAVx | GuKKjuGsyI |
Output data
same | string1 | string2 | time |
---|---|---|---|
-1 | RJqcVGNlcJ | rjQCvGNLCj | 2022-01-01T00:00:00Z |
1 | unfbcNAXUA | hBumdSljCQ | 2022-01-01T00:01:00Z |
0 | ITcHyLZuqu | ITcHyLZuqu | 2022-01-01T00:02:00Z |
-1 | HyXdjvrjgp | hyxDJvrJGP | 2022-01-01T00:03:00Z |
1 | SVepvUBAVx | GuKKjuGsyI | 2022-01-01T00:04:00Z |
{{% /expand %}} {{< /expand-wrapper >}}