string transform functions

The following scalar string functions are available:

• reverse(text) — reverses the string.
• tolower(text) — lowercases using invariant culture.
• toupper(text) — uppercases using invariant culture.
• replace_string(text, lookup, rewrite) — replaces all occurrences of lookup with rewrite (ordinal).

All inputs are converted to string. Return type is string.

Specs

reverse(text)
tolower(text)
toupper(text)
replace_string(text, lookup, rewrite)

Parameters

• text: Source string.
• lookup: Substring to find.
• rewrite: Replacement substring.

Return value

string with the requested transformation applied.

Examples

Reverse:

datatable(s:string)["abc", "racecar"]
| extend reversed = reverse(s)

Case conversions:

datatable(s:string)["MiXeD"]
| extend lower = tolower(s), upper = toupper(s)

Replace substring:

datatable(text:string)[ "hello world" ]
| extend swapped = replace_string(text, "world", "there")

text	swapped
hello world	hello there