MobileRead Forums - View Single Post - bulk copy from one column to another: is it ok to delete original column?

anoukaimee · 10-21-2023, 05:03 PM

This might be a stupid question, but I know very little about regex--just what I've taught myself; please bear with me.

I figured out how to do a mass search and replace to move my old GoodReads "F_rating" data (plugin deprecated, I think) into a new one that pulls from the Goodreads metadata plugin, thereby consolidating all data in one column.

I would like to now delete the original "F_rating" data column, but I want to be sure that won't also delete the data that is now in the new column. I don't know Python, but I do use Excel a ton, if you just delete a cell that has been replicated it will delete the content of the replicated cell--because you're deleting the underlying formula (unless you copy the value of an item from one cell to another).

I don't think this is the case with the Calibre language but would like to be sure before I delete the source column: has the data actually been copied, so that I can delete the original column, or is it still dependent on the contents of the original column?

Thanks much.

10-21-2023, 05:03 PM	#1
anoukaimee Enthusiast Posts: 30 Karma: 10 Join Date: Aug 2017 Location: USA Device: Kobo Clara, Pixel 6 (Moon Reader/Calibre Companion), Amazon Fire 10	bulk copy from one column to another: is it ok to delete original column? This might be a stupid question, but I know very little about regex--just what I've taught myself; please bear with me. I figured out how to do a mass search and replace to move my old GoodReads "F_rating" data (plugin deprecated, I think) into a new one that pulls from the Goodreads metadata plugin, thereby consolidating all data in one column. I would like to now delete the original "F_rating" data column, but I want to be sure that won't also delete the data that is now in the new column. I don't know Python, but I do use Excel a ton, if you just delete a cell that has been replicated it will delete the content of the replicated cell--because you're deleting the underlying formula (unless you copy the value of an item from one cell to another). I don't think this is the case with the Calibre language but would like to be sure before I delete the source column: has the data actually been copied, so that I can delete the original column, or is it still dependent on the contents of the original column? Thanks much.