Split Text to Column if Capital Letter within a Word

[Flo]

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.

[sumitiiest]

Hi @Flo ,

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

Thanks,

Sumit