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"