trim_end()

Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel

Removes trailing match of the specified regular expression.

Syntax

trim_end(regex, source)

Learn more about syntax conventions.

Parameters

Returns

source after trimming matches of regex found in the end of source.

Examples

The following statement trims substring from the end of string_to_trim.

let string_to_trim = @"bing.com";
let substring = ".com";
print string_to_trim = string_to_trim,trimmed_string = trim_end(substring,string_to_trim)

Output

Trim non-alphanumeric characters

The following example trims all non-word characters from the end of the string.

print str = strcat("-  ","Te st",x,@"// $")
| extend trimmed_str = trim_end(@"[^\w]+",str)

Output

Trim whitespace

The following example trims all spaces from the end of the string.

let string_to_trim = @"    Hello, world!    ";
let substring = @"\s+";
print
    string_to_trim = string_to_trim,
    trimmed_end = trim_end(substring, string_to_trim)

Output