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 Data into multiple Separate Fields-- no regular pattern

Hello Community,

I'm trying to split a row into multiple fields here.

example: Family (Animated)PGFY20

               DramaRFY20

               Family (Animated)PG-13FY20

Well if I use the right([string],4) 

I will get the fiscal year  i.e fy20 as a new column.

But I'm unable to figure out how do i get the remaining columns  

Expected output:

 

Capture.PNG

 

Can pls anyone help me here

Thanks

Alteryx Certified Partner

You can use regular expressions in the regex tool (see screenshot). There's enough of a pattern to get your three records to parse correctly, though it might fail on more, less well behaved rows....

 

Regex - Capture.PNG

Highlighted

hi @PhilipMannering 

Thanks for the Solution. Cheers!

Labels