Duplicate/Copy column
Is there a way to duplicate or copy a non-user defined column?
I have a large library and my TAG columns are a real mess. I would like to clean them up but it will take a while. In the mean time, I don't want to delete the existing tags as they would be useful in until the update is complete,
My first thought was to create a user-defined column called 'My Tags' and use it to represent the new organized tags. However, what I really want is the original TAG column to have the updated tags. So if I do this, I have to find a way to copy/overwrite the data in 'My Tags' into the original 'Tags' once its complete. I have no idea how to do that.
My second thought was to duplicate the original TAGS column, and then simply erase the data in the original TAG column and add the new tags directly using the copied column as reference. When I am finished, I would simply delete the other column. However, I have no idea how to duplicate the column.
Any advice would be appreciated.
(Note: Please don't say just to use the new column 'My Tags'. I know that is an option, but if I export or transfer books, the other user would have to have that column in order for the data to transfer. Everyone automatically has the TAG column, so that is why I want that original column to have the updated data.
Thanks in advance!
|