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 >}}