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
Solved! Go to 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....
Thanks for the Solution. Cheers!