Text.MiddleText.Middle

SintaxeSyntax

Text.Middle(text as nullable text, start as number, optional count as nullable number) as nullable text

SobreAbout

Retorna count caracteres ou até o final de text; no deslocamento start.Returns count characters, or through the end of text; at the offset start.

Exemplo 1Example 1

Encontre a substring no texto "Olá, Mundo" iniciando no índice 6 abrangendo 5 caracteres.Find the substring from the text "Hello World" starting at index 6 spanning 5 characters.

Text.Middle("Hello World", 6, 5)

"World"

Exemplo 2Example 2

Encontre a substring no texto "Olá, Mundo" iniciando no índice 6 até o final.Find the substring from the text "Hello World" starting at index 6 through the end.

Text.Middle("Hello World", 6, 20)

"World"