Chris Webb points out a new function in Power BI:
It’s very easy to use: the first parameter takes a text value, the second parameter takes either a text value containing a single text value or a list of single characters, and it returns the text from the first parameter minus all characters that are not in the second parameter. For example, the expression:
Text.Select("Hello", "l")…returns the text value “ll”
Click through to see an example of how you can use this to filter out punctuation and other unwanted characters.