Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Add white space

Meshal10
7 - Meteor

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? 

3 REPLIES 3
Blake
12 - Quasar

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. 

 

Blake_0-1602624233273.png

 

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
7 - Meteor

Thank you so much it works great.

maamek
7 - Meteor

What if you have other lower case afterwards like RockySpringsresortoverseas

Labels