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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Parse and Separate Multiple Names with and without Spaces

Meteor

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

Meteor

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

Alteryx Partner
Alteryx Partner

Hello @PWaicus ,

 

this should do it :)

 

Cheers

Meteor

This is great.  Thank you very much!

Labels