Split to rows when string starts with specific characters

Question

Hi

I am quite new with Alteryx and would like to split to rows when my sting starts with specific characters.

I have tried to use text to column -> does not seem to work properly since if I use DAD as a delimiter it would take that off.

The data is like this : 
DADAUG5045075DADAUG5045075747000 AU13C95410300008158 DADAUG504

And I would need it this way :

DADAUG5045075

DADAUG5045075747000 AU13C95410300008158

DADAUG504

Your help will be really much appreciated.

Thanks,

Lorenna

JohnJPS · Accepted Answer

HI @munnelor,

Try preceding "Text To Columns" with a formula that replaces "DAD" with "|DAD" (or use some special character you do not expect to otherwise see in the data).  Then use that character in the "Text to Columns" tool to split to rows.

Hope that helps!

John

CharlieS · Accepted Answer

Looks like @JohnJPS had the same idea as I was building this when he posted. Well done!