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

alteryx server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.
Alteryx Gallery is experiencing a problem in which system emails are not being sent out. As a result, if you are attempting to sign up for a new account, you may be unable to verify your email address. We are working to solve this as soon as possible and will remove this notice once resolved.

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