Text.Middle
Returns the substring up to a specific length.
function (optionaltext
as nullable any,start
as number, optionalcount
as nullable any) as nullable any
Returns
count
characters, or through the end of text
; at the offset start
.Text.Extraction
Find the substring from the text "Hello World" starting at index 6 spanning 5 characters.
Text.Middle("Hello World", 6, 5)
"World"
Find the substring from the text "Hello World" starting at index 6 through the end.
Text.Middle("Hello World", 6, 20)
"World"
Last modified 4yr ago