replace_regex()
Replaces all regex matches with another string.
Syntax
replace_regex(text,regex, rewrite)
Arguments
- text: A string.
- regex: The regular expression to search text. The expression can contain capture groups in parentheses.
- rewrite: The replacement regex for any match made by matchingRegex. Use
\0to refer to the whole match,\1for the first capture group,\2and so on for subsequent capture groups.
Returns
source after replacing all matches of regex with evaluations of rewrite. Matches do not overlap.
See also
- For string matching, see replace_string().
- For replacing a set of characters, see translate().
Example
range x from 1 to 5 step 1
| extend str=strcat('Number is ', tostring(x))
| extend replaced=replace_regex(str, @'is (\d+)', @'was: \1')
Results
| x | str | replaced |
|---|---|---|
| 1 | Number is 1.000000 | Number was: 1.000000 |
| 2 | Number is 2.000000 | Number was: 2.000000 |
| 3 | Number is 3.000000 | Number was: 3.000000 |
| 4 | Number is 4.000000 | Number was: 4.000000 |
| 5 | Number is 5.000000 | Number was: 5.000000 |