trim_start()

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

Removes leading match of the specified regular expression.

trim_start(regex, source)

Learn more about syntax conventions.

source after trimming match of regex found in the beginning of source.

The following example trims substring from the start of string_to_trim.

let string_to_trim = @"https://bing.com";
let substring = "https://";
print string_to_trim = string_to_trim,trimmed_string = trim_start(substring,string_to_trim)

Output

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

range x from 1 to 5 step 1
| project str = strcat("-  ","Te st",x,@"// $")
| extend trimmed_str = trim_start(@"[^\w]+",str)

Output

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

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

Output