Text.Range
Returns the substring found at offset.
function (optionaltext
as nullable any,offset
as number, optionalcount
as nullable any) as nullable any
Returns the substring from the text
text
found at the offset offset
. An optional parameter, count
, can be included to specify how many characters to return. Throws an error if there aren't enough characters.Text.Extraction
Find the substring from the text "Hello World" starting at index 6.
Text.Range("Hello World", 6)
"World"
Find the substring from the text "Hello World Hello" starting at index 6 spanning 5 characters.
Text.Range("Hello World Hello", 6, 5)
"World"
Last modified 4yr ago