Move selected data from series column to a new custom column

fvdham · 06-01-2017, 03:29 PM

I have a custom column defined as a series +series index column. I like to move the info (series name and index) from the series column to the other column for a selected number of books.
Is there a simple way to do this? I have to move the info for many many books so retyping is hardly an option.
I have looked at this forum but could not find an answer

theducks · 06-01-2017, 03:44 PM

Piece of Cherry Cake

Use the Search and Replace function of Bulk Metadata edit
Search (.+) in original column
Replace \1 in Destination
REGEX mode

fvdham · 06-02-2017, 03:06 PM

Thanks for your quick respons. It's working. I only have to do the move in 3 parts. First the serie name, than the serie index and than delete the info in the sending column. It's no big deal.
I will start studying the regex options. I have never used it before.

theducks · 06-02-2017, 03:49 PM

Quote:

Originally Posted by fvdham

Thanks for your quick respons. It's working. I only have to do the move in 3 parts. First the serie name, than the serie index and than delete the info in the sending column. It's no big deal.
I will start studying the regex options. I have never used it before.

Ah! Series. as you discovered, this is a 2 parter. My regex was for Text or numbers

06-01-2017, 03:29 PM	#1
fvdham Connoisseur Posts: 52 Karma: 10 Join Date: Jun 2012 Location: Zaandam, The Netherlands Device: sony PRS-T1 / Kobo Glo HD	Move selected data from series column to a new custom column I have a custom column defined as a series +series index column. I like to move the info (series name and index) from the series column to the other column for a selected number of books. Is there a simple way to do this? I have to move the info for many many books so retyping is hardly an option. I have looked at this forum but could not find an answer

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how to move tags data into a new custom column	smoothrolla	Library Management	6	05-30-2018 07:19 AM
Auto-tag with custom column data	lazorbeam	Library Management	9	01-21-2016 11:36 PM
how to move value(s) of tag column to a custom made column	zoorakhan	Library Management	0	12-08-2012 03:53 AM
Metadata Plugboard Data in a Custom Column	nynaevelan	Library Management	2	01-10-2012 12:54 PM
Can custom book data be displayed in a custom column?	kiwidude	Development	9	03-02-2011 05:35 AM

06-01-2017, 03:44 PM	#2
theducks Well trained by Cats Posts: 29,799 Karma: 54830978 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	Piece of Cherry Cake Use the Search and Replace function of Bulk Metadata edit Search (.+) in original column Replace \1 in Destination REGEX mode

06-02-2017, 03:06 PM	#3
fvdham Connoisseur Posts: 52 Karma: 10 Join Date: Jun 2012 Location: Zaandam, The Netherlands Device: sony PRS-T1 / Kobo Glo HD	Thanks for your quick respons. It's working. I only have to do the move in 3 parts. First the serie name, than the serie index and than delete the info in the sending column. It's no big deal. I will start studying the regex options. I have never used it before.

Advert