Documentation

regexp.replaceAllString() function

The regexp.replaceAllString() function replaces all regular expression matches in a string with a specified replacement.

Output data type: String

import "regexp"

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

// Returns "-T-T-"

Parameters

r

The regular expression used to search v.

v

The string value to search.

t

The replacement for matches to r.

Examples

Replace regular expression matches in string column values
import "regexp"

data
    |> map(fn: (r) => ({r with
        message: r.message,
        updated_message: regexp.replaceAllString(
            r: /cat|bird|ferret/,
            v: r.message,
            t: "dog",
        )
    }))

Was this page helpful?

Thank you for your feedback!


Upgrade to InfluxDB Cloud or InfluxDB 2.0!

InfluxDB Cloud and InfluxDB OSS 2.0 ready for production.