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 · Accepted solution]

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

[Chandler_Bing]

hi @PhilipMannering 

Thanks for the Solution. Cheers!