Split to rows when string starts with specific characters

[munnelor]

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 solution]

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 solution]

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