Text.Middle
Returns a specified number of characters starting from a designated position within the text. If no specific count is provided, it will return characters up to the end of the text from the specified s...
Text.Middle(text as nullable text, start as number, optional count as nullable number) as nullable textReturns a specified number of characters starting from a designated position within the text. If no specific count is provided, it will return characters up to the end of the text from the specified starting point.
Identify the portion of text "Hello World" starting at position 6 and including 5 characters.
Usage:
Power Query MText.Middle("Hello World", 6, 5)
Result:
"World"
Identify the portion of text "Hello World" starting at position 6 till the end.
Usage:
Power Query MText.Middle("Hello World", 6, 20)
Result:
"World"