Re: [libreoffice-users] [3.5.3.2/Calc] Can it renumber lines from subtitle file?

Hi :)
Ouch!  Use a proper tool for the job!  I use Gaupol 
http://www.softpedia.com/get/Multimedia/Video/Other-VIDEO-Tools/Gaupol.shtml
but there are plenty of others to choose from.  

You probably can do this with Calc or other spreadsheet program but it's going to make a right 
mess.  

Which platform are you using?  Windows, Gnu&Linux (such as Ubuntu, Mageia), Mac or something else?  
If Gnu&Linux just type "subtitle" into your package manager and you will see tons of programs for 
doing this sort of thing.

Regards from
Tom :)  



--- On Sat, 1/9/12, Gilles <codecomplete@free.fr> wrote:

From: Gilles <codecomplete@free.fr>
Subject: [libreoffice-users] [3.5.3.2/Calc] Can it renumber lines from subtitle file?
To: users@global.libreoffice.org
Date: Saturday, 1 September, 2012, 23:15

Hello

Here's the problem:
- an AVI video file with a few seconds removed when it was ripped from the
original DVD
- the subtitle .sub file that still contains the full data

Here's what a .sub file looks like:
---------------------
{65364}{65474}<first line that I need to remove>
...
{66534}{66572}<last line I need to removed>
---------------------

At about 2/3 into the movie, the extra, useless subtitles are displayed,
which means that the subtitles and the video no longer match. This means
that after removing the useless section, I must renumber the rest of the
start/end for each line.

Before I write a Python script tomorrow morning, do you know if can Calc do
this?

Thank you.



--
View this message in context: 
http://nabble.documentfoundation.org/3-5-3-2-Calc-Can-it-renumber-lines-from-subtitle-file-tp4004958.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted