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!

afv2688

Hello @PWaicus ,

this should do it

Cheers

parsenames.yxmd