Split text string to different columns

Hi,

Alternatively you can achieve the same by using formula as well

For first column:
=LEFT(A1,SEARCH("]",A1))

For second column:
=MID(A1,LEN(B1)+3,SEARCH("Query",A1,LEN(B1))-LEN(B1)+3)

for third column:
=MID(A1,LEN(B1)+LEN(C1)+3,8)

for forth column:
=RIGHT(A1,LEN(A1)-LEN(B1)-LEN(C1)-LEN(D1)-4)