String cuts in column data

[Ra Nala]

Hi,

i am using MySQL 5.7 version.

I am facing problem with string cuts, may be it is very tricky one but i am not getting logic, could you please help me. my client is expecting results in below table way.

Data should be stored in call_date, contact_name,service_rep_name,comments columns individually.

comments String 1:
[CALL DATE : 11/23/2015] [CONTACT NAME : venki palama] [SERVICE REP NAME : sudhakar mare] Please send a picture showing the overlay harness and connections made

comments String 2:
[CALL DATE : 1/6/2015] [CONTACT NAME : nagaraju kaner] [SERVICE REP NAME : bharath karem ] Looks like the performance option/feature 40439-05 was purchased


call_date contact_name service_repair_name comments
---------- ------------ ------------------- ---------
11/23/2015 venki palama sudhakar mare Please send a picture showing the overlay harness and connections made
1/6/2015 nagaraju kaner bharath karem Looks like the performance option/feature 40439-05 was purchased

thank you