community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Split to rows when string starts with specific characters

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 

ACE Emeritus
ACE Emeritus

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

 

Highlighted
Alteryx Certified Partner

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

 

 

Labels