Chris Scarpulla
New Member
Hey fellow gurus!
Hoping to get a hand with the following:
I'm using Power Query to pull game data from a website, and there are instances where I need to insert a space before a capital letter, but ONLY if the preceding letter is NOT a capital letter.
I found a few VBA solutions that get me halfway there, but they all insert a space before each and every capital, which just doesn't get me where I need to be.
Here are a few examples from the data.
Before CloudmusiqIntercontinental Cup
After Cloudmusiq Intercontinental Cup
Before Maplethorpe TyresPre-Season Euro Cup
After Maplethorpe Tyres Pre-Season Euro Cup
Before Aston MartinDB9Showcase
After Aston Martin DB9 Showcase
Before SupaflySpeed Test
After Supafly Speed Test
This one is a bit different.
Before Circuit des 24 Heures(Night)
After Circuit des 24 Heures (Night)
The source data is here: http://rr3.wikia.com/wiki/Luxury_Tourer_Tournament
Thanks in advance!
Chris
Hoping to get a hand with the following:
I'm using Power Query to pull game data from a website, and there are instances where I need to insert a space before a capital letter, but ONLY if the preceding letter is NOT a capital letter.
I found a few VBA solutions that get me halfway there, but they all insert a space before each and every capital, which just doesn't get me where I need to be.
Here are a few examples from the data.
Before CloudmusiqIntercontinental Cup
After Cloudmusiq Intercontinental Cup
Before Maplethorpe TyresPre-Season Euro Cup
After Maplethorpe Tyres Pre-Season Euro Cup
Before Aston MartinDB9Showcase
After Aston Martin DB9 Showcase
Before SupaflySpeed Test
After Supafly Speed Test
This one is a bit different.
Before Circuit des 24 Heures(Night)
After Circuit des 24 Heures (Night)
The source data is here: http://rr3.wikia.com/wiki/Luxury_Tourer_Tournament
Thanks in advance!
Chris