Any way to merge 2 cudtom columns?

Down South · 11-04-2013, 07:41 PM

Was given a friends Calibre library.
He has a custom column "Genre" which is Comma separated text, like tags, shown in the tag browser.

I have "Category" column which is Text, columns shown in the tag browser.

The Column type is greyed out and can't seem to be changed in both custom columns or I would change the type to match and the names to be the same and then import the smaller 6,000+ books library.

Any ideas how I can merge them or do I have to create a third column combining the contents of the 2 above?

theducks · 11-04-2013, 08:32 PM

Quote:

Originally Posted by Down South

Was given a friends Calibre library.
He has a custom column "Genre" which is Comma separated text, like tags, shown in the tag browser.

I have "Category" column which is Text, columns shown in the tag browser.

The Column type is greyed out and can't seem to be changed in both custom columns or I would change the type to match and the names to be the same and then import the smaller 6,000+ books library.

Any ideas how I can merge them or do I have to create a third column combining the contents of the 2 above?

3rd seems to be the choice if the 2 columns are different types (and it is probably the easiest)
Try using the bulk Metadata edit to copy the contents to the new column

chaley · 11-05-2013, 05:52 AM

You can use bulk edit search and replace to add the contents of the "Category" column to the end of "Genre" column. This works because genre is a multiple-value column. You can't go the other way because category is a single-value column.

Be sure to back up you library before starting the experiments. Bulk search & replace has no undo ...

Down South · 11-08-2013, 05:26 PM

Thank you all.
Glad I asked, and really thankful you answered.

30 seconds to modify my generic regex and apply it on 3 books.

10 seconds to save it.
60 more to select the 10609 books of Catalog and apply the copy regex.
Dancing in the streets . . . . priceless, since I don't dance.:thanks

The power and flexibility of Calibre still amazes me.

11-04-2013, 07:41 PM	#1
Down South Junior Member Posts: 7 Karma: 10 Join Date: Jun 2013 Device: Kindle Keyboard	Any way to merge 2 cudtom columns? Was given a friends Calibre library. He has a custom column "Genre" which is Comma separated text, like tags, shown in the tag browser. I have "Category" column which is Text, columns shown in the tag browser. The Column type is greyed out and can't seem to be changed in both custom columns or I would change the type to match and the names to be the same and then import the smaller 6,000+ books library. Any ideas how I can merge them or do I have to create a third column combining the contents of the 2 above?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Un-Merge?	4Catsnadog	Library Management	6	08-22-2011 03:46 PM
Just What Does Merge Do?	Pinecone	Library Management	5	01-29-2011 06:43 AM
What exactly does merge do?	bigpallooka	Calibre	15	11-24-2010 06:58 PM
Merge feature request (different merge)	Tarran	Calibre	1	05-24-2010 10:57 AM
how to merge annotations	sputnik	iRex	3	06-05-2008 05:49 PM

11-05-2013, 05:52 AM	#3
chaley Grand Sorcerer Posts: 12,444 Karma: 8012886 Join Date: Jan 2010 Location: Notts, England Device: Kobo Libra 2	You can use bulk edit search and replace to add the contents of the "Category" column to the end of "Genre" column. This works because genre is a multiple-value column. You can't go the other way because category is a single-value column. Be sure to back up you library before starting the experiments. Bulk search & replace has no undo ...

11-08-2013, 05:26 PM	#4
Down South Junior Member Posts: 7 Karma: 10 Join Date: Jun 2013 Device: Kindle Keyboard	Thank you all. Glad I asked, and really thankful you answered. 30 seconds to modify my generic regex and apply it on 3 books. 10 seconds to save it. 60 more to select the 10609 books of Catalog and apply the copy regex. Dancing in the streets . . . . priceless, since I don't dance.:thanks The power and flexibility of Calibre still amazes me.

Advert