I have a database that holds data for magazines. However, there is one merchant feed that holds a lot of needed information in one field. Is there any way to take something like this:

magazine_title|magazine_description|New Renewal 1 Year 12 Issues For $9.95 2 Years 24 issues (+9.00) $18.95 3 Years 36 Issues (+18.00) $27.95|blahblah|blahblah

can be turned into:


There needs to be one complete entry for each subscription length due to the way that my database is set up and how queries are run.

Also, not all titles have 3 different subscription lengths, some have 1, some have 2.

Thanks for any suggestions.