Split Data into multiple Separate Fields-- no regular pattern

Chandler_Bing

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:

Can pls anyone help me here

Thanks

philipmannering

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....