Muokkaa

Jaa

replace_string()

  • Artikkeli

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