trim()
Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel
Removes all leading and trailing matches of the specified regular expression.
trim(
regex,
source)
Learn more about syntax conventions.
Name | Type | Required | Description |
---|---|---|---|
regex | string |
✔️ | The string or regular expression to be trimmed from source. |
source | string |
✔️ | The source string from which to trim regex. |
source after trimming matches of regex found in the beginning and/or the end of source.
The following example trims substring from the start and the end of the string_to_trim.
let string_to_trim = @"--https://bing.com--";
let substring = "--";
print string_to_trim = string_to_trim, trimmed_string = trim(substring,string_to_trim)
Output
string_to_trim | trimmed_string |
---|---|
--https://bing.com-- |
https://bing.com |
The following example trims all non-word characters from start and end of the string.
range x from 1 to 5 step 1
| project str = strcat("- ","Te st",x,@"// $")
| extend trimmed_str = trim(@"[^\w]+",str)
Output
str | trimmed_str |
---|---|
- Te st1// $ | Te st1 |
- Te st2// $ | Te st2 |
- Te st3// $ | Te st3 |
- Te st4// $ | Te st4 |
- Te st5// $ | Te st5 |
The next statement trims all spaces from start and end of the string.
let string_to_trim = @" Hello, world! ";
let substring = @"\s+";
print
string_to_trim = string_to_trim,
trimmed_string = trim(substring, string_to_trim)
Output
string_to_trim | trimmed_string |
---|---|
Hello, world! | Hello, world! |