इसके माध्यम से साझा किया गया


Text.Middle

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"