Adding a space between two names

Question

Hello Alteryx Community,

I have a situation where I have a fictitious list of names such as the below:

NameDeanEmmaroseJamesSarahjane

What I need to do in the case of say Emmarose and SarahJane is just put a space between the names so it would look like Emma rose for example.

It is probably not to difficult but I just can't figure out a way to do it thanks to the community as always for any help

OzlemSigbeku · Answer

Let me know if this doesn't solve your issue.

DataIsFun_Name_demo.yxmd

DataIsFun · Answer

Hi @OzlemSigbeku That would be helpful to have a look and see how it would look

OzlemSigbeku · Answer

It would be hard to do this without a specific rule to signify the second name e.g. a capitalized letter for the surname (EmmaRose rather than Emmarose). In that case you can use a regex tool to parse our the first and second name and a formula tool to bring the two parsed fields together with a and added ' '. I can upload a workflow if useful.