Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!See when key Fabric features will launch and what’s already live, all in one place and always up to date. Explore the new Fabric roadmap
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
Solved! Go to Solution.
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
Proud to be a Datanaut!
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
Proud to be a Datanaut!