Parsing phoenix array data

Question

Phoenix data sample for element X1:
['[A, B, C, D, E]', '[A1, B1,C1, D1, E1]','[A2, B2, C2, D2, E2]','[A3, B3, C3, D3, E3]']

There are a variable number of [a, b, c, d, e] blocks for data element X1.

I want to parse array sub items A,C,E of data element X1 in to separate columns and then next set of a1, C1, E2 in to the next row, and loop through the unknown (x) number A,C,E groups.
final output example

col1	Col2	Col3
A	C	E
A1	C1	E1
A2	C2	E2
Ax	Cx	Ex

Answer 1

等待大神答复