Break up data from one column into multiple columns in a new table (MySQL)

[tersos]

I have a table full of data, where one column is full of different entries for each row, where the data is formatted like this:A:some text|B:some other text|C:some more text|I want to separate those strings of text into two columns on a new table. So the new table should have one column for A, B, C etc. and the other column will have the rest of the text in their respective rows.And there is another value (a DATETIME value) in a separate column of the first table that I would like to copy into a third column for each of the separated entries.Let me know if this needs clarificaiton, I know it's kind of confusing and I'm pretty fuzzy with MySQL. Thanks!