fnCleanText in Power Query M

Notes

Save this as its own query named fnCleanText, then call it from other queries with Table.TransformColumns(Source, {{ColumnName, fnCleanText, type text}}).

Requirements

• None - this is a standalone reusable function; call it from any query in the same file.

How to use this snippet

1. In Power BI Desktop, choose Transform data to open Power Query, then open the Advanced Editor on a query (or start from a blank query).
2. Paste the snippet and replace the placeholder names (tables, columns, file paths) with your own. Check the requirements above first.
3. Run it through the Power Query M Formatter to tidy the layout.

Related Power Query M snippets

• Trim and Clean All Text ColumnsApplies trim and clean to every text column in a table at once, without naming columns individually.
• fnBusinessDaysA reusable custom function that returns the number of weekdays between two dates.
• Create a Reusable Custom FunctionDefines a query as a function so it can be called with different arguments from other queries.

More Power Query M resources

Browse all 145 snippets in the Power Query M Code Snippets, or search the library for something similar to fnCleanText.