Add white space

[Meshal10]

Hi, I have tried hard to add a space between two words, but I have not found the solution yet.

Actual data = RockSprings

Desired data = Rock Springs

Does anyone know how to add white space between words? 

[Blake · Accepted solution]

Hi @Meshal10 

Do your new words always start with a capital letter? If so, the attached set of tools may work well for you by parsing out the individual words using regex tokenize and rolling them back up using a Summarize tool. 

I'm working under the assumption that you have a list of a bunch of words that are smashed together. This will only work if all the words in your string start with a capital letter and are followed by lowercase letters. A bit larger sample of data could help me (and the community) build this in a way that works best with your data. 

[Meshal10]

Thank you so much it works great.

[Magneto_]

What if you have other lower case afterwards like RockySpringsresortoverseas