← Back to Text functions

Text.Select

The function returns a modified version of the input text, where all the characters not specified in the selectChars parameter are removed.

Syntax

Text.Select(text as nullable text, selectChars as any) as nullable text

About

The function returns a modified version of the input text, where all the characters not specified in the selectChars parameter are removed.

Explanation

Identify and extract all characters between 'a' and 'z' from the given text value using Power Query MText function. Usage: Power Query MText.Select("a,b;c", {"a".."z"}) Result: "abc"