Hey,<br><br>I put together a script containing couple of sql queries to make this thing happen.<br>First sql removes ':'-characters from the beginning of recording titles, then the title is separated to subtitle and title. If needed I will add extra check what makes sure that the subtitle needs to be empty do this thing.<br>
<br>#!/usr/bin/perl -w<br>use strict;<br>use MythTV;<br>my $jobid = -1;<br>my $mt = new MythTV();<br>my $db = $mt->{'dbh'};<br><br>sub Die($)<br>{<br> print STDERR "@_\n";<br> exit -1;<br>}<br><br>
my ($query);<br><br>$query = $db->prepare("update recorded set title = SUBSTRING_INDEX(title,\':\', -1) where title like \":\%\";");<br>$query->execute || Die "Unable to remove :";<br>
$query->finish;<br><br>$query = $db->prepare("update recorded set subtitle = SUBSTRING_INDEX(title, \':\', -1) where title like \"\%:\%\";");<br>$query->execute || Die "Unable to set subtitle";<br>
$query->finish;<br><br>$query = $db->prepare("update recorded set title = SUBSTRING_INDEX(title, \':\', 1) where title like \"\%:\%\";");<br>$query->execute || Die "Unable to update title";<br>
$query->finish;<br><br><br><div class="gmail_quote">On Sat, Jul 18, 2009 at 7:14 PM, Tomi Makinen <span dir="ltr"><<a href="mailto:makinen@gmail.com">makinen@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
thanks for the thread, looks promising. <br><br>Well I think if the modification is done only when subtitle is empty, it would work, atleast for me ..<br><br>Will look into this in more detail when I found enough time..<div>
<div></div><div class="h5"><br>
<br><div class="gmail_quote">On Tue, Jul 14, 2009 at 5:48 AM, Nick Rout <span dir="ltr"><<a href="mailto:nick.rout@gmail.com" target="_blank">nick.rout@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Trouble is some programmes genuinely have a colon in the name, like CSI:Miami.<br>
<br>
In the meantime you might like this thread:<br>
<br>
<a href="http://www.gossamer-threads.com/lists/mythtv/mythtvnz/362706" target="_blank">http://www.gossamer-threads.com/lists/mythtv/mythtvnz/362706</a><br>
<div><br>
On Tue, Jul 14, 2009 at 8:07 AM, Tomi Makinen<<a href="mailto:makinen@gmail.com" target="_blank">makinen@gmail.com</a>> wrote:<br>
> Thanks for replies...<br>
><br>
> It might be that I try to make a script for this. The eit data does not need<br>
> any adjustment when changing to summer time or winter time.. thats the main<br>
> reason to sticking with it..<br>
<br>
</div>Trouble is some programmes genuinely have a colon in the name, like CSI:Miami.<br>
<br>
In the meantime you might like this thread:<br>
<br>
<a href="http://www.gossamer-threads.com/lists/mythtv/mythtvnz/362706" target="_blank">http://www.gossamer-threads.com/lists/mythtv/mythtvnz/362706</a><br>
<div><div></div><div><br>
><br>
_______________________________________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a><br>
<a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users" target="_blank">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a><br>
</div></div></blockquote></div><br>
</div></div></blockquote></div><br>