I have a text box that contains a value of
"A/A,B/B,C-F/D-G,H+M+N/O+P,Q/Q"

I need to load this value if two diff array

First ARRAY should contain
A
B
C-F
H+M+N
Q

second array should contain
A
B
D-G
O+P
Q

Legend:
"," is a delimiter
"/" is an array delimiter . entry on the left side of the "/" belongs to the first array and string on the right side of the "/" is for the second array.

Is there a easy way to do this other than inspecting each value in a loop?.

My project is to do a spreadsheet comparison by Column or multiple column or range and concatination of multiple column values.