Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Split to rows when string starts with specific characters

munnelor
5 - Atom

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 

2 REPLIES 2
JohnJPS
15 - Aurora

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
17 - Castor
17 - Castor

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

 

 

Labels