This produces the string "Jacked" in the temp field.Ĥ. In another temp field, take the episode name (Custom1) and replace the problem string (Custom3) with nothing.Ĭode: Select all update zEntry set zCustom4 = replace(zCustom1,zCustom3,'') This produces the string "Numb3rs - " in the temp field.ģ.
Create the problem string in a temporary custom field:Ĭode: Select all update zEntry set zCustom3 = zTitle || ' - ' Example episode name problem: Numb3rs - Jacked. Thanks to your other SQLite tips, I was able to get some ideas and solve the problem.ġ. If you have the original EyeTV files you could remove the entries and drag over the EyeTV files again to create new entries with the correct information. Update zEntry set zCustom1 = replace(zCustom1, 'The Simpsons – ', '') Update custom1 again for the correct number and change the series name to match.Ĭonor Top Dog Posts: 5319 Joined: Sat 12:58 pmĬonor wrote:Unfortunately, the SQLite functions (type of database we use) are a bit limited and there is no way to split the episode information out by looking for the dash character. If you have many of a single series then remove the series name from the newly set episode name with the command (leaving you only with the removing the episode name from the title field by hand): Update zEntry set zCustom1 = zTitle where zCustom1 is null Need to replace custom1 for the number of the custom field that you set as episode name. Sqlite3 ~/Library/Application\ Support/DVDpedia/Database.pediadata Starts up SQLite3 with the DVDpedia database. Run the program named Terminal and execute the following commands one line at a time: Otherwise, the SQLite can at least be used to copy the title information into the episode field, making it easier to delete the irrelevant information without having to copy/paste.įirst make a copy of the database file as backup, located in ~/Library/Application Support/DVDpedia/Database.pediadata
Unfortunately, the SQLite functions (type of database we use) are a bit limited and there is no way to split the episode information out by looking for the dash character.