Remove Extra Spaces and Commas - TRIM in Power Query
Input - I love Excel, Power Query,,,,,SQL,,, ,, Python.
Output - I love Excel, Power Query, SQL, Python.
In Power Query, TRIM Function doesn't work as it does in Excel. In Power Query, it only TRIMS from Start or End or both but not the extra characters in middle of the text.
In this Video, we shall see a workaround for dealing with situations in which we have extra Spaces or Commas or any other specified delimiter in the middle of text.
