Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Switch services using the Version drop-down list. Learn more about navigation.
Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel
Replaces all string matches with a specified string.
Deprecated aliases: replace()
To replace multiple strings, see replace_strings().
Syntax
replace_string(text, lookup, rewrite)
Learn more about syntax conventions.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| text | string |
✔️ | The source string. |
| lookup | string |
✔️ | The string to be replaced. |
| rewrite | string |
✔️ | The replacement string. |
Returns
Returns the text after replacing all matches of lookup with evaluations of rewrite. Matches don't overlap.
Examples
Replace words in a string
The following example uses replace_string() to replace the word "cat" with the word "hamster" in the Message string.
print Message="A magic trick can turn a cat into a dog"
| extend Outcome = replace_string(
Message, "cat", "hamster") // Lookup strings
Output
| Message | Outcome |
|---|---|
| A magic trick can turn a cat into a dog | A magic trick can turn a hamster into a dog |
Generate and modify a sequence of numbers
The following example creates a table with column x containing numbers from one to five, incremented by one. It adds the column str that concatenates "Number is " with the string representation of the x column values using the strcat() function. It then adds the replaced column where "was" replaces the word "is" in the strings from the str column.
range x from 1 to 5 step 1
| extend str=strcat('Number is ', tostring(x))
| extend replaced=replace_string(str, 'is', 'was')
Output
| 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 |
Related content
- To replace multiple strings, see replace_strings().
- To replace strings based on regular expression, see replace_regex().
- To replace a set of characters, see translate().