Removing Excess Spaces Between Words AKA Inner Trim (Power BI)

Text.Trim() does an excellent job of getting rid of things like

 "   leading spaces"

and

"trailing spaces     "

but unlike its’ Excel cousin it doesn’t handle

"excess     inner       spaces"

at all.

Granted these problems aren’t as ubiquitous as the first two (which show up in hand generated Excel data and web data all the time), but if you need them gone you need them gone. In this video, we show you a cool way to leverage Text.Split() and Text.Combine() to isolate shed those pesky double spaces and knock them out of your precious data for good.

Happy Reporting!!

Share This:
Twitter
Facebook
LinkedIn

Stay up to date with the latest customer data news, expert guidance, and resources.

Iteration and Error Handling in M Query

All iteration roads in M Query eventually lead to the List.Generate function. In strengthening our data manipulation skills through Power Query, we absolutely need this looping function.

More Resources

Trusted By Over 6 Million End Users​

Industry leaders and over 6 million end users choose SkyPoint as their comprehensive and compliant Modern Data Stack Platform. A Gold Certified Microsoft Partner, SkyPoint Cloud turns siloed customer data into connected customer experiences.