Some older database applications may export all composer and all publisher data (name, affiliation, share ..) to a single column, when you export the metadata to a comma separated or tab delimited file.
The NetMix system stores each composer name, affiliation and share in a separate column as recommended in the "metadata standard for production music" developed by the PMA (Production Music Association).
Example of incorrectly formatted Composer column:
Example of correctly formatted Composer columns per NetMix and PMA standard:
IF your source data is consistently formatted and contains a 'delimiter', then you can use a function in Excel to split the composer and publisher data into multiple columns.
Excel has a feature called "Convert Text to Columns":
How to use "Convert Text to Columns" is explained on the Microsoft website:
0 Comments