When cleaning dirty data, you might have used the Trim-function (Text.TrimStart or Text.TrimEnd) to delete leading or trailing whitespace from your strings. However, did you know that you could use (…) Read more
Posts Tagged ‘Text transformation’
Improved Text.SplitAny – function for Power BI and Power Query
Today I’ll present an adjustment to the Text.SplitAny – function in Power BI’s query editor or Power Query. The native function takes a string as an input and splits the (…) Read more
Return all occurrences of text between delimiters in Power BI and Power Query
The M-function Text.BetweenDelimiters does what it says and returns the text between 2 delimiters in the query editor of Power BI and Power Query. But irrespective of its optional arguments (…) Read more
Transform text with exceptions in Power BI and Power Query
Recently I picked up an interesting request to transform text with exceptions: Transform the words in a column to proper case, but keep certain keywords like in a defined list. (…) Read more