Remove Quotes from DVD Titles

Talk to other Pedia users about the programs, share tricks and tips or ask questions about existing features.
Post Reply
scorysto
Junior Member
Junior Member
Posts: 3
Joined: Mon Dec 07, 2009 3:34 pm

Remove Quotes from DVD Titles

Post by scorysto »

I imported my collection from another program and all the movies titles had quotations around them I was wondering if there was away to delete the quotation marks with out having to do it on all 500 entries by hand. :(
User avatar
Nora
Site Admin
Posts: 2155
Joined: Sun Jul 04, 2004 5:03 am
Contact:

Re: Remove Quotes from DVD Titles

Post by Nora »

There is no find and replace in DVDpedia but you can use the open standard SQL database to make the changes.

1. Make a backup of your database file in ~/Library/Application Support/DVDpedia/Database.dvdpd
2. Quit DVDpedia
3. Open the program called Terminal in your utilities folder.
4. Copy paste the following lines one at a time into terminal and press return after each one:

Code: Select all

sqlite3 ~/Library/Application\ Support/DVDpedia/Database.dvdpd
update Zentry Set Ztitle = replace(Ztitle, '"', '');
.exit
5. Launch DVDpedia

Be aware that this replace will remove all double quotes in the title field, so you might have to add one or two back, but I can't think of any movie with a double quote in the title.
scorysto
Junior Member
Junior Member
Posts: 3
Joined: Mon Dec 07, 2009 3:34 pm

Re: Remove Quotes from DVD Titles

Post by scorysto »

Worked Beautifully. Thank you. I mean even with the double quotes in there it still found everything in alphabetical order it was just an OCD moment. So thanks agian.
Post Reply