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 <[email protected]> wrote: From: Gilles <[email protected]> Subject: [libreoffice-users] [3.5.3.2/Calc] Can it renumber lines from subtitle file? To: [email protected] 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: [email protected] 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: [email protected] 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
