Parse and Separate Multiple Names with and without Spaces

[PWaicus]

Hi.  I have a field that contains multiple individuals' first and last names; however, there is no space between the first individual's last name and the next individual's first name.  I'm trying to separate them out - please see below:

Examples:

1)  John SmithBob Jones

2)  Sally JohnsonBob JonesAmy Johnson

Desired Outcomes:

1)  John Smith/Bob Jones

2)  Sally Johnson/Bob Jones/Amy Johnson

Thanks!

[yalmar_m]

Hi @PWaicus,

Is the first letter of both surname and lastname the only uppercases in your datasource?

Best,

Yalmar

[PWaicus]

Hi - Correct.  I've been trying to use Regex with \l and \u but haven't had any luck.

[afv2688 · Accepted solution]

Hello @PWaicus ,

this should do it :)

Cheers

[PWaicus]

This is great.  Thank you very much!