Alteryx Server

Find answers, ask questions, and share expertise about Alteryx Server.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.

Split Text to Column if Capital Letter within a Word

Highlighted
5 - Atom

Hi All,

 

I'm trying to split this string into two columns based on the capital letter - I've been looking for a while to figure out how to do this, but didn't fin the appropriate answer (yet)... Can someone help? Here's a sample of the data:

 

Company

Beauty and the Beast HairstylingHairdresser

Michael AndersPhotographer

Martin DesulsoChimney Sweeper

 

And the desired output:

CompanyDescription
Beauty and the Beast HairstylingHairdresser
Michael AndersPhotographer
Martin DesulsoChimney Sweeper

 

Thanks guys, really appreciate your help.

 

This was supposed to be posted in the Designer discussion - sorry for the confusion.

Highlighted
8 - Asteroid

Hi @Flo ,

 

I have attached the Alteryx workflow which can parse the data based on Capital letter within word.

 

Thanks,

Sumit