ContextQMD
Back to Influxdb

regexp.replaceAllString() function

content/flux/v0/stdlib/regexp/replaceallstring.md

latest3.3 KB
Original Source
<!------------------------------------------------------------------------------ IMPORTANT: This page was generated from comments in the Flux source code. Any edits made directly to this page will be overwritten the next time the documentation is generated. To make updates to this documentation, update the function comments above the function definition in the Flux source code: https://github.com/influxdata/flux/blob/master/stdlib/regexp/regexp.flux#L148-L148 Contributing to Flux: https://github.com/influxdata/flux#contributing Fluxdoc syntax: https://github.com/influxdata/flux/blob/master/docs/fluxdoc.md ------------------------------------------------------------------------------->

regexp.replaceAllString() replaces all reguar expression matches in a string with a specified replacement.

Function type signature
js
(r: regexp, t: string, v: string) => string

{{% caption %}} For more information, see Function type signatures. {{% /caption %}}

Parameters

r

({{< req >}}) Regular expression used to search v.

v

({{< req >}}) String value to search.

t

({{< req >}}) Replacement for matches to r.

Examples

Replace regular expression matches in a string

js
import "regexp"

regexp.replaceAllString(r: /a(x*)b/, v: "-ab-axxb-", t: "T")// Returns "-T-T-"

Replace regular expression matches in string column values

js
import "regexp"
import "sampledata"

sampledata.string()
    |> map(fn: (r) => ({r with _value: regexp.replaceAllString(r: /smpl_/, v: r._value, t: "")}))

{{< expand-wrapper >}} {{% expand "View example input and output" %}}

Input data

_time*tag_value
2021-01-01T00:00:00Zt1smpl_g9qczs
2021-01-01T00:00:10Zt1smpl_0mgv9n
2021-01-01T00:00:20Zt1smpl_phw664
2021-01-01T00:00:30Zt1smpl_guvzy4
2021-01-01T00:00:40Zt1smpl_5v3cce
2021-01-01T00:00:50Zt1smpl_s9fmgy
_time*tag_value
2021-01-01T00:00:00Zt2smpl_b5eida
2021-01-01T00:00:10Zt2smpl_eu4oxp
2021-01-01T00:00:20Zt2smpl_5g7tz4
2021-01-01T00:00:30Zt2smpl_sox1ut
2021-01-01T00:00:40Zt2smpl_wfm757
2021-01-01T00:00:50Zt2smpl_dtn2bv

Output data

_time_value*tag
2021-01-01T00:00:00Zg9qczst1
2021-01-01T00:00:10Z0mgv9nt1
2021-01-01T00:00:20Zphw664t1
2021-01-01T00:00:30Zguvzy4t1
2021-01-01T00:00:40Z5v3ccet1
2021-01-01T00:00:50Zs9fmgyt1
_time_value*tag
2021-01-01T00:00:00Zb5eidat2
2021-01-01T00:00:10Zeu4oxpt2
2021-01-01T00:00:20Z5g7tz4t2
2021-01-01T00:00:30Zsox1utt2
2021-01-01T00:00:40Zwfm757t2
2021-01-01T00:00:50Zdtn2bvt2

{{% /expand %}} {{< /expand-wrapper >}}