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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
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

hi @PhilipMannering 

Thanks for the Solution. Cheers!

Labels