Re: [libreoffice-users] auto edit youtube transcript?

At 20:39 15/05/2021 -0700, Dave Stevens wrote:
> Here's a snippet of a youtube auto-generated CC transcript. Can 
> someone show how to delete the lines that have times? as far as i 
> know they are strictly alternating and have exactly 1 colon, but that's
> where my smarts end. Anyone have a suggestion?

If you indeed just need to remove all odd-numbered lines of the text, 
you could do this:

o Paste the material into column A of a spreadsheet, starting at A1 - 
so that each line occupies one cell.
o In cell B1 (say), enter =OFFSET(A$1,ROW()*2-1,0)
o Fill down column B.

I think this works whether your original "lines" are separated by 
line breaks or are actually separate paragraphs. You can copy and 
paste the material in column B back into a text document for further 
formatting as required, of course.

I trust this helps.

Brian Barker


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy