Geek asks and answers

Rewriting a comma divides data into structured

I have a table consisting of the headings Category and Subcategories
In the heading of subcategories for each category, I have a list of subcategories, separated by commas. <Br / ">

I would like to rewrite the data in a new table so that the sub-categories, separated by commas, are on separate lines with the corresponding category in the previous column.

If anyone has any ideas on how to do this, I would be very grateful.

+3
source share
1 answer

One idea is to output your data and then use a function like PHP to parse it and insert it into a new table.

+2

More articles:


All Articles