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) , but it varies... some are 5 spaces, some are 7 spaces.. or do you have a better way?

 

 

SOUTH BEACH FOOD MART #4732       01/05

ALTON ROAD LIQUORS      215487 01/07

THE HOME DEPOT     01/08 Cash Back $20.00

 

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

1 Reply

  • 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