Text.At

This function retrieves a specific character from a given text value at the specified position, known as the index. It is worth noting that the first character in the text is located at position 0.

Syntax

Text.At(text as nullable text, index as number) as nullable text

About

This function retrieves a specific character from a given text value at the specified position, known as the index. It is worth noting that the first character in the text is located at position 0.

Explanation

Locate the character at index 4 in the string "Hello, World" using the Power Query MText.At function. The output will be "o".