Remove Quotes from DVD Titles

[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.

[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]

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.