Include a space between a lower case letter and an upper case letter

Hello,

I'm new to Alteryx and after using a number of 'ReplaceChar' formula to remove unwanted characters in my data and I've ended up with the following:

Essentially I want to add a space between the lower case letter and the upper case letter, with a view to using the 'Text to Columns' tool to separate City and County in my dataset.

Assuming the solution will lie in the Formula tool?

Thanks,

Help

Accepted answers

MarqueeCrew

@arundaka02

I used:

REGEX_Replace([CityCounty], "(\u\l+)(\u.*)", '$1 $2',0)

to solve your challenge.

it takes the first group of 1 uppercase plus multiple lowercase letters and adds a space before the next uppercase letter.

Cheers,

Mark

All comments

MarqueeCrew

@arundaka02

I used:

REGEX_Replace([CityCounty], "(\u\l+)(\u.*)", '$1 $2',0)

to solve your challenge.

it takes the first group of 1 uppercase plus multiple lowercase letters and adds a space before the next uppercase letter.

Cheers,

Mark

jacob_kahn

@MarqueeCrew

Thank you - this is awesome to use!

arundaka02

@MarqueeCrew

Thank you for this, and for providing a breakdown/explanation of the syntax. Solved!

SabrinaPaoli

What would the formula be if there are three words I am trying to separate with spaces - all starting with capital letters?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703