Copy data from one column to another

Wyndham · 11-16-2013, 07:18 AM

I made a mistake by setting up a column with an html type format, so the data displays (for example) in Book Covers with the formatting - (eg) <p>Complete</p>

I have now set up the column correctly (basically just plain text) and was hoping there was a way to copy the data from the old column to the new one.

Unless there is a better way to do this.

Adoby · 11-16-2013, 08:01 AM

You can (Not tested!) edit metadata in bulk and use search and replace with a regular expression to copy the data.

For instance search for html tags and copy what is between them.

For example:
Search the html field for: <p>(.*)</p>
And replace the text field with: \1

chaley · 11-16-2013, 09:50 AM

You can copy from one column to another with bulk edit search and replace. You must use regular expression mode to see the choice of separate source and destination columns

Wyndham · 11-19-2013, 01:14 PM

Thanks for responding. It took a little while to figure out how to enable regular expressions but once I found it, your advice worked.

Thank you both.

11-16-2013, 07:18 AM	#1
Wyndham Connoisseur Posts: 96 Karma: 250 Join Date: Mar 2011 Location: Cricklewood (London) Device: iPad Air 2 (iOS 9), iPhone 6 (iOS 9)	Copy data from one column to another I made a mistake by setting up a column with an html type format, so the data displays (for example) in Book Covers with the formatting - (eg) <p>Complete</p> I have now set up the column correctly (basically just plain text) and was hoping there was a way to copy the data from the old column to the new one. Unless there is a better way to do this.

11-16-2013, 08:01 AM	#2
Adoby Handy Elephant Posts: 1,736 Karma: 26785668 Join Date: Dec 2009 Location: Southern Sweden, far out in the quiet woods Device: Thinkpad E595, Ubuntu Mate, Huawei Mediapad 5, Bouye Likebook Plus	You can (Not tested!) edit metadata in bulk and use search and replace with a regular expression to copy the data. For instance search for html tags and copy what is between them. For example: Search the html field for: <p>(.)</p> And replace the text field with: \1 Last edited by Adoby; 11-16-2013 at 08:03 AM.*

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Make calculations using column data	Katsunami	Calibre	1	11-12-2013 09:33 PM
Column copy (one time)	wsignal	Library Management	6	05-08-2013 04:41 PM
Can't get {size} data in a User Column?	CCarrot	Calibre	16	06-26-2012 11:39 AM
Need help with programming a column based on previous data in the same column	seaquay	Library Management	2	06-13-2012 12:19 PM
Color new sd card - copy data over? (cm7)	thaKing	Nook Color & Nook Tablet	3	12-08-2011 11:14 AM

11-16-2013, 09:50 AM	#3
chaley Grand Sorcerer Posts: 11,799 Karma: 7029971 Join Date: Jan 2010 Location: Notts, England Device: Kobo Libra 2	You can copy from one column to another with bulk edit search and replace. You must use regular expression mode to see the choice of separate source and destination columns

11-19-2013, 01:14 PM	#4
Wyndham Connoisseur Posts: 96 Karma: 250 Join Date: Mar 2011 Location: Cricklewood (London) Device: iPad Air 2 (iOS 9), iPhone 6 (iOS 9)	Thanks for responding. It took a little while to figure out how to enable regular expressions but once I found it, your advice worked. Thank you both.