SuperDB

Function

  regexp_replace — replace regular expression matches in a string

Synopsis

regexp_replace(s: string, re: string, new: string) -> string

Description

The regexp_replace function substitutes all characters matching the regular expression re in string s with the string new.

Variables in new are replaced with corresponding matches drawn from s. A variable is a substring of the form $name or ${name}, where name is a non-empty sequence of letters, digits, and underscores. A purely numeric name like $1 refers to the submatch with the corresponding index; other names refer to capturing parentheses named with the (?P<name>...) syntax. A reference to an out of range or unmatched index or a name that is not present in the regular expression is replaced with an empty string.

In the $name form, name is taken to be as long as possible: $1x is equivalent to ${1x}, not ${1}x, and, $10 is equivalent to ${10}, not ${1}0.

To insert a literal $ in the output, use $$ in the template.

Examples

Replace regular expression matches with a letter

# spq
values regexp_replace(this, "ax*b", "T")
# input
"-ab-axxb-"
# expected output
"-T-T-"

Replace regular expression matches using numeric references to submatches

# spq
values regexp_replace(this,
                     r"(\w+):\s+(\w+)$",
                     "$1=$2")
# input
"option: value"
# expected output
"option=value"

Replace regular expression matches using named references

# spq
values regexp_replace(this,
                     r"(?P<key>\w+):\s+(?P<value>\w+)$",
                     "$key=$value")
# input
"option: value"
# expected output
"option=value"

Wrap a named reference in curly braces to avoid ambiguity

# spq
values regexp_replace(this,
                     r"(?P<key>\w+):\s+(?P<value>\w+)$",
                     "$key=${value}AppendedText")
# input
"option: value"
# expected output
"option=valueAppendedText"