docs-v2/content/flux/v0/stdlib/regexp/replaceallstring.md

title	description	menu	weight
regexp.replaceAllString() function	`regexp.replaceAllString()` replaces all reguar expression matches in a string with a specified replacement.	flux_v0_ref name parent identifier regexp.replaceAllString regexp regexp/replaceAllString	101

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

Function type signature

(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
• Replace regular expression matches in string column values

Replace regular expression matches in a string

import "regexp"

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

Replace regular expression matches in string column values

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:00Z	t1	smpl_g9qczs
2021-01-01T00:00:10Z	t1	smpl_0mgv9n
2021-01-01T00:00:20Z	t1	smpl_phw664
2021-01-01T00:00:30Z	t1	smpl_guvzy4
2021-01-01T00:00:40Z	t1	smpl_5v3cce
2021-01-01T00:00:50Z	t1	smpl_s9fmgy

_time	*tag	_value
2021-01-01T00:00:00Z	t2	smpl_b5eida
2021-01-01T00:00:10Z	t2	smpl_eu4oxp
2021-01-01T00:00:20Z	t2	smpl_5g7tz4
2021-01-01T00:00:30Z	t2	smpl_sox1ut
2021-01-01T00:00:40Z	t2	smpl_wfm757
2021-01-01T00:00:50Z	t2	smpl_dtn2bv

Output data

_time	_value	*tag
2021-01-01T00:00:00Z	g9qczs	t1
2021-01-01T00:00:10Z	0mgv9n	t1
2021-01-01T00:00:20Z	phw664	t1
2021-01-01T00:00:30Z	guvzy4	t1
2021-01-01T00:00:40Z	5v3cce	t1
2021-01-01T00:00:50Z	s9fmgy	t1

_time	_value	*tag
2021-01-01T00:00:00Z	b5eida	t2
2021-01-01T00:00:10Z	eu4oxp	t2
2021-01-01T00:00:20Z	5g7tz4	t2
2021-01-01T00:00:30Z	sox1ut	t2
2021-01-01T00:00:40Z	wfm757	t2
2021-01-01T00:00:50Z	dtn2bv	t2

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