11-16-2013, 07:18 AM | #1 |
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 |
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. |
11-16-2013, 09:50 AM | #3 |
Grand Sorcerer
Posts: 11,947
Karma: 7225107
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 |
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. |
Tags |
column, copy data, formatting |
|
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 |