Forum Discussion

ilcaa722's avatar
ilcaa722
Frequent Visitor
3 years ago
Solved

Find Consecutive whitespace >2

I want to just get the name of the business only, so im thinking of find the starting point when 2 or more consecutive white spaces occur then I can Text.Start length-start of consectuive white space...
Need Help
  • BA_Pete's avatar
    BA_Pete
    3 years ago

    Hi ilcaa722 ,

     

    Select your column in Power Query, go to the Transform tab > Split Column (dropdown) > by Delimiter.

    Enter double-space as a custom delimiter then select to only split at the left-most delimiter:

     

    Pete

BA_Pete's avatar
BA_Pete
Super User
3 years ago

Hi ilcaa722 ,

 

Select your column in Power Query, go to the Transform tab > Split Column (dropdown) > by Delimiter.

Enter double-space as a custom delimiter then select to only split at the left-most delimiter:

 

Pete