Put Space between lower and upper case letters

Question

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

Raj · Answer

@saachitalwar 
try this 
hope this helps.

please mark done if the issue is solved.

876.yxmd

alexnajm · Answer

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.

saachitalwar · Answer

no replies to the rest of the test cases