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

Chandler_Bing
8 - Asteroid

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

2 REPLIES 2
PhilipMannering
16 - Nebula
16 - Nebula

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

Chandler_Bing
8 - Asteroid

hi @PhilipMannering 

Thanks for the Solution. Cheers!

Labels