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

alteryx server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.

Split Text to Column if Capital Letter within a Word

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.

Asteroid

Hi @Flo ,

 

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

 

Thanks,

Sumit