Split Text to Column if Capital Letter within a Word

Flo — Thu, 16 May 2019 08:50:44 GMT

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:

Company	Description
Beauty and the Beast Hairstyling	Hairdresser
Michael Anders	Photographer
Martin Desulso	Chimney Sweeper

Thanks guys, really appreciate your help.

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

Re: Split Text to Column if Capital Letter within a Word

sumitiiest — Thu, 16 May 2019 11:04:35 GMT

Hi @Flo ,

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

Thanks,

Sumit

topic Re: Split Text to Column if Capital Letter within a Word in Alteryx Server Discussions

Split Text to Column if Capital Letter within a Word

Re: Split Text to Column if Capital Letter within a Word