List of authors for all items in a collection
I would like to create a list of author first and last names for all the items in a collection. Any easy way to do this? Even better if the list has only unique authors (no duplicates).
-
aurimasYou can export metadata for items as CSV and play with it in Excel.
-
adamsmithI'd start with exporting to CSV, you should be able to get the list pretty easily once you're in Excel and since you can sort, weeding out duplicates is easy too.
-
Gurdas_SandhuThanks, aurimas and adamsmith. Tried it, looks workable. In my exported list, all the author names are in one column, each author separated by a semi-colon. Probably because my export style uses semi-colons and what I need is a style that uses commas to separate authors? Which style/s would that be?
-
adamsmithno, you can't customize that easily, but you can obviously do search&replace, including to split authors up into separate columns/fields if you need to.
-
Gurdas_SandhuOkay, sounds like a plan. I'll report back here if something does not work.