How can I separate name by capital letter?

[benbenjoy]

For example, if there are a bunch of names as following, how can I separate it by the capital letter of the second name?

AndrewAton      ->       Andrew Aton  

HarryPorter        ->       Harry Porter

JamesSmith     ->         James Smith

Thanks!

[LordNeilLord · Accepted solution]

Hi,

In the regex tool you can use the expression (\u\w+)(\u\w+) with the parse method: