Page 1 of 1
Remove Quotes from DVD Titles
Posted: Mon Dec 07, 2009 3:42 pm
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.
Re: Remove Quotes from DVD Titles
Posted: Mon Dec 07, 2009 6:11 pm
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.
Re: Remove Quotes from DVD Titles
Posted: Tue Dec 08, 2009 1:45 am
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.