community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Parse and Separate Multiple Names with and without Spaces

Atom

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!

Alteryx Partner

Hi @PWaicus,

 

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

 

Best,

Yalmar

Atom

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

Alteryx Partner

Hello @PWaicus ,

 

this should do it :)

 

Cheers

Atom

This is great.  Thank you very much!

Labels