Parsing comma delimited data in a single column in a table
Posted on 2011-03-07
I am (repeatedly) importing an excel file, and one of the columns in the excel file has a "list" in it. So for instance, the data might be:
Animal | Attributes
Giraffe| African, tall, yellow, spotted
Panda| Asian, black and white, herbivore
I want to put the animal information into one table (easy), and the list of ALL attributes in another table.
Do I need to code this or is there a way to write a query that will read each individual attribute in the attribute column and put one word at a time in the Attribute table?