Put Space between lower and upper case letters

[saachitalwar]

Hi,

I have a few test cases where the strings need to have some spaces included:

input - desired output

1. ABCdefOneTwoThree - ABCdef One Two Three

2. ABCdefU.S.TwoThree - ABCdef U.S. Two Three

3. ABCdef100%TwoThree - ABCdef 100% Two Three

the formula - Regex_replace([Field1],'([a-z])([A-Z])','$1 $2',0) - worked perfectly for the first test case but the rest are coming out like ABCdef U.S.Two Three with the . and the next capital letter joined.

How can the rest of the test cases be divided into the desired strings

[alexnajm]

I think this is already being addressed on the other thread you started yesterday: Re: Divide String ABCadMunicipalMarketBudget to AB... - Page 2 - Alteryx Community

Please continue there so we don't flood up the discussion board. Thank you!

[saachitalwar]

no replies to the rest of the test cases 

[alexnajm]

Still, it is better to continue on one thread than to start a new one (unless it is a completely different question). It looks like there's a reply now for example.

[Raj]

@saachitalwar 
try this 
hope this helps.

please mark done if the issue is solved.