Nota
L-aċċess għal din il-paġna jeħtieġ l-awtorizzazzjoni. Tista’ tipprova tidħol jew tibdel id-direttorji.
L-aċċess għal din il-paġna jeħtieġ l-awtorizzazzjoni. Tista’ tipprova tibdel id-direttorji.
Syntax
Text.Middle(
text as nullable text,
start as number,
optional count as nullable number
) as nullable text
About
Returns count characters, or through the end of text; at the offset start.
Example 1
Find the substring from the text "Hello World" starting at index 6 spanning 5 characters.
Usage
Text.Middle("Hello World", 6, 5)
Output
"World"
Example 2
Find the substring from the text "Hello World" starting at index 6 through the end.
Usage
Text.Middle("Hello World", 6, 20)
Output
"World"
Example 3
Find the substring from the text "Hello World" starting at index 0 spanning 2 characters.
Usage
Text.Middle("Hello World", 0, 2)
Output
"He"