Returns the substring up to a specific length.
function (optional
text
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"