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"
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for