replace a part of the title

Lauraq · 05-23-2015, 07:00 AM

Hi

I have a long list of books that have this name:

title vol. 1
title vol. 2
title vol. 3

how do I replace "vol." with "-?
I want it to be called:

title - 1
title - 2
title - 3

BetterRed · 05-23-2015, 07:27 AM

Quote:

Originally Posted by Lauraq

Hi

I have a long list of books that have this name:

title vol. 1
title vol. 2
title vol. 3

how do I replace "vol." with "-?
I want it to be called:

title - 1
title - 2
title - 3

@Lauraq - you can use the Bulk metadata edit->Search and Replace feature to do what you want - this should get you started:

Click image for larger version

Name: Capture.JPG
Views: 180
Size: 120.4 KB
ID: 138554

Suggest you backup your library first - bulk S&R especially on the Author and Title columns are potentially dangerous.

BR

Lauraq · 05-23-2015, 08:23 AM

Thanks for your help!

I know the function but do not know how to use it, there are too many options, do not understand why things so complicated

ops is not so difficult, it is I who am clumsy

BetterRed · 05-23-2015, 08:46 AM

@Lauraq

Set Search Mode to Character Match
Check Case Sensitive
Set Apply function after replace to Blank
click on the Search field bar - select 'title' - near the bottom of list
In Search for enter the character(s) you want to replace - 'vol.'
In Replace with enter the character(s) you want to substitute - '-'

Don't worry about the multiple-value fields parameters they don't apply

If the Test results are as you want them - click the Apply button. If they're not then take a screen shot and post here with explanation of what's wrong.

Ah, ah - looks like you had success

BR

theducks · 05-23-2015, 11:00 AM

Quote:

Originally Posted by Lauraq

Thanks for your help!

I know the function but do not know how to use it, there are too many options, do not understand why things so complicated

ops is not so difficult, it is I who am clumsy

It is not simple because this is an advanced feature.

It is doing Open Heart (DB) Surgery, not a kiss on an 'ow-y'
One slip and the patient may not survive, or at least be crippled for life.

BACKUP first
do not try for a 'All in One Shot' solution. Pick a specific metadata issue and fix that.

Apply to a tiny test case of books

Verify the reslts

do more/the rest

Lauraq · 05-23-2015, 11:45 AM

for theducks
I made a backup first

But is all ok

for BetterRed
Thanks for your help and for the little faq, very helpful

05-23-2015, 07:00 AM	#1
Lauraq Zealot Posts: 111 Karma: 10 Join Date: Nov 2013 Device: not one	replace a part of the title Hi I have a long list of books that have this name: title vol. 1 title vol. 2 title vol. 3 how do I replace "vol." with "-? I want it to be called: title - 1 title - 2 title - 3

05-23-2015, 08:23 AM	#3
Lauraq Zealot Posts: 111 Karma: 10 Join Date: Nov 2013 Device: not one	Thanks for your help! I know the function but do not know how to use it, there are too many options, do not understand why things so complicated ops is not so difficult, it is I who am clumsy Last edited by Lauraq; 05-23-2015 at 08:32 AM.

05-23-2015, 08:46 AM	#4
BetterRed null operator (he/him) Posts: 20,568 Karma: 26954694 Join Date: Mar 2012 Location: Sydney Australia Device: none	@Lauraq Set Search Mode to Character Match Check Case Sensitive Set Apply function after replace to Blank click on the Search field bar - select 'title' - near the bottom of list In Search for enter the character(s) you want to replace - 'vol.' In Replace with enter the character(s) you want to substitute - '-' Don't worry about the multiple-value fields parameters they don't apply If the Test results are as you want them - click the Apply button. If they're not then take a screen shot and post here with explanation of what's wrong. Ah, ah - looks like you had success BR

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Glo Only part of the screen updates - fix or replace?	MikeNorrish	Kobo Reader	7	05-16-2014 01:18 AM
adding book : series is part of the whole title	Dragouf	Library Management	4	07-19-2013 12:52 AM
Date no longer part of News Title	JohnPearce	Recipes	4	03-24-2012 03:58 PM
Regex - replace only part of a string - how?	flameproof	Sigil	11	02-23-2012 04:43 AM
ISBN look up, usually missing part of title	thibaulthalpern	Calibre	7	05-06-2009 01:57 AM

05-23-2015, 11:45 AM	#6
Lauraq Zealot Posts: 111 Karma: 10 Join Date: Nov 2013 Device: not one	for theducks I made a backup first But is all ok for BetterRed Thanks for your help and for the little faq, very helpful

Advert

Advert