Stream Transcripts

code-1839406_640Have played around with Microsoft Stream a little recently but only briefly, when I spotted someone having issues exporting the automatically created transcripts.     The issue is the transcripts are formatted with time codes and the person wanted only the text of the transcript without all of the timecodes.   Removing manually was a pain but thankfully the format of the transcript files appeared uniform in nature…….time to roll out the Macro code and some VBA

As such I put together the below simple VBA code to delete the timecode lines and leave only the text.   Will admit the code isn’t particularly tidy but my intention was to simply hack together a solution as opposed to creating elegant code.

The Code:

Sub Macro1()

Dim introw As Integer

introw = 7

Do While Cells(introw, 1).Value <> “”

Rows(introw – 2).EntireRow.Delete
Rows(introw – 2).EntireRow.Delete
Rows(introw – 1).EntireRow.Delete
introw = introw + 1

Loop

End Sub

Now I will admit that I havent tested the code on more than a basic level, having run it on a couple of transcripts I have.   Please let me know if you have issues with it.

*Update: It would appear WordPress converts the minus ( – ) character in my code to a similar looking character in the above.   As such you may get a syntax error if copying and pasting.  If so just delete and replace the minus with the correct character in your code.

Advertisement

Author: garyhenderson2014

Gary Henderson is currently the Director of IT in an Independent school in the UK. Prior to this he worked as the Head of Learning Technologies working with public and private schools across the Middle East. This includes leading the planning and development of IT within a number of new schools opening in the UAE. As a trained teacher with over 15 years working in education his experience includes UK state secondary schools, further education and higher education, as well as experience of various international schools teaching various curricula. This has led him to present at a number of educational conferences in the UK and Middle East.

One thought on “Stream Transcripts”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: