https://community.fabric.microsoft.com/t5/Webinars-and-Video-Gallery/Removing-Excess-Spaces-Between-Words-AKA-Inner-Trim/m-p/153116#M24 <P>Text.Trim() does an excellent job of getting rid of things like " &nbsp; leading spaces" and "trailing spaces &nbsp; &nbsp;"; but unlike its' Excel cousin it doesn't handle&nbsp;"excess &nbsp; &nbsp;inner &nbsp; &nbsp;spaces". &nbsp;Granted these problems aren't as ubiquitous&nbsp;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.&nbsp;</P><P>&nbsp;</P><P>Happy Reporting!</P><P>&nbsp;</P><P><SPAN class="videoUrl hidden">watch?v=vPqXLRpQO5E</SPAN></P> Tue, 04 Apr 2017 00:55:24 GMT BrianGrant 2017-04-04T00:55:24Z https://community.fabric.microsoft.com/t5/Webinars-and-Video-Gallery/Removing-Excess-Spaces-Between-Words-AKA-Inner-Trim/m-p/153116#M24 <P>Text.Trim() does an excellent job of getting rid of things like " &nbsp; leading spaces" and "trailing spaces &nbsp; &nbsp;"; but unlike its' Excel cousin it doesn't handle&nbsp;"excess &nbsp; &nbsp;inner &nbsp; &nbsp;spaces". &nbsp;Granted these problems aren't as ubiquitous&nbsp;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.&nbsp;</P><P>&nbsp;</P><P>Happy Reporting!</P><P>&nbsp;</P><P><SPAN class="videoUrl hidden">watch?v=vPqXLRpQO5E</SPAN></P> Tue, 04 Apr 2017 00:55:24 GMT https://community.fabric.microsoft.com/t5/Webinars-and-Video-Gallery/Removing-Excess-Spaces-Between-Words-AKA-Inner-Trim/m-p/153116#M24 BrianGrant 2017-04-04T00:55:24Z