Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management

Notices

Reply
 
Thread Tools Search this Thread
Old 11-16-2013, 07:18 AM   #1
Wyndham
Connoisseur
Wyndham has a complete set of Star Wars action figures.Wyndham has a complete set of Star Wars action figures.Wyndham has a complete set of Star Wars action figures.
 
Wyndham's Avatar
 
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.
Wyndham is offline   Reply With Quote
Old 11-16-2013, 08:01 AM   #2
Adoby
Handy Elephant
Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.
 
Adoby's Avatar
 
Posts: 1,358
Karma: 8222870
Join Date: Dec 2009
Location: Southern Sweden, far out in the quiet woods
Device: Ubuntu LTS, 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.
Adoby is online now   Reply With Quote
Advert
Old 11-16-2013, 09:50 AM   #3
chaley
CC Android & calibre dev
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 8,756
Karma: 2655962
Join Date: Jan 2010
Location: France
Device: Many android devices
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
chaley is offline   Reply With Quote
Old 11-19-2013, 01:14 PM   #4
Wyndham
Connoisseur
Wyndham has a complete set of Star Wars action figures.Wyndham has a complete set of Star Wars action figures.Wyndham has a complete set of Star Wars action figures.
 
Wyndham's Avatar
 
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.
Wyndham is offline   Reply With Quote
Reply

Tags
column, copy data, formatting

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

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


All times are GMT -4. The time now is 02:42 PM.


MobileRead.com is a privately owned, operated and funded community.