Forum Discussion

drusome's avatar
drusome
Copper Contributor
Jun 08, 2020
Solved

VTT Cleaner website missing

I googled and found this post in the wrong forum:

The website is down.  Was it removed?

 

https://docs.microsoft.com/answers/users/2648818/michellel-2384.html asked · 15 hours ago

https://docs.microsoft.com/en-us/stream/media/stream-utils/cleanvtt.html

Hello, Can you please tell me why the web address has been removed? This VTT cleaner was extremely helpful.

https://docs.microsoft.com/en-us/stream/media/stream-utils/cleanvtt.html

 

 

19 Replies

  • lizramos24's avatar
    lizramos24
    Copper Contributor

    @https://docs.microsoft.com/answers/users/2648818/michellel-2384.html Hello, have you gotten any feedback on this? 

    Thank you! 

  • drusome I've been cleaning my VTTs via Excel. I documented how to do that in a video here; https://www.youtube.com/watch?v=t274fWR1mIo 

    • EthanHarrell's avatar
      EthanHarrell
      Copper Contributor

      New link everyone!

      https://amsglob0cdnstream13.azureedge.net/vttcleaner/CleanVTT.html

      • Robb74's avatar
        Robb74
        Copper Contributor
        Unfortunately this link that I've been using in recent years is now gone as well.
  • drusome naomiii  ericlott KWildman Thx to everyone in this thread for participating till now!
     
    I could access the cached version of the VTTCleaner and view the html source. I extracted the code and I have written a PowerShell script to clean a VTT file. It is in my GitHub repo now. See: https://github.com/tomka75/Tools/tree/master/MicrosoftStream/VTTCleaner
     
    Call:
    .\Clean-MicrosoftStreamVttFile.ps1 -File MicrosoftStreamVideoTranscriptDemo.vtt
     
    Result is a clean text output in file MicrosoftStreamVideoTranscriptDemo.vttcleaned.
     
    I hope this can help someone!

    • JMBiCons's avatar
      JMBiCons
      Copper Contributor

      Hi Tomislav Karafilov. Just wanted to say a BIG high 5 for your share of the VTTCleaner code  (and an equally big thanks to @Marc Mroz. for the original).  This has saved HOURS of work. I'm a happy person this evening 🙂

       

      • Jon_Wiggy's avatar
        Jon_Wiggy
        Copper Contributor

        This works if you set output as plain text: https://toolslick.com/conversion/subtitle/all

         

    • KWildman's avatar
      KWildman
      Copper Contributor
      Fab, thanks a lot, I'll check it out!
  • KWildman's avatar
    KWildman
    Copper Contributor

    Hi drusome and everyone, I did some searching (I couldn't use the cached file that one of the responders mentioned). So I did some searching and found these instructions. They clean the VVT file just like the microsoft docs link did. There's a few steps but super easy, takes a few minutes. Hope this helps.

     

    - Copy and paste all text from the VVT file into Excel. Select all.

    - Do a find and replace on NOTE* and replace with a blank

    - Do a find and replace on *-* and replace with a blank

    - Then to get rid of the blank rows, do ctrl G to open the "Go to" popup. Click "Special". Select "Blanks".

    - In the Home menu of Excel, go to the "Cells" section. Click the "Delete" drop down and select "delete sheet rows".

    - Copy the text to Word, use the paste special function to copy just the text so as not to copy the text in the rows.

    - In Word: do CTRL A to select all, CTRL H to find and replace, click MORE, then under special, choose paragraph mark, then replace all.

    - Your data is now ready for editing. :stareyes:

    • ericlott's avatar
      ericlott
      Copper Contributor

      Hi KWildman and all,

       

      https://subtitletools.com/convert-subtitles-to-plain-text-online

       

      Found this on anther thread dealing with this and wanted to pass on here. Makes pretty quick work of it. 

       

      Best

       

       

  • naomiii's avatar
    naomiii
    Copper Contributor

    I also just noticed the VTT cleaner missing. This app was indispensable for making sense of Stream transcripts! Not sure what else to use... drusome 

    • drusome's avatar
      drusome
      Copper Contributor

      Hi naomiii ,

       

      I did a google search for VTTcleaner, and then clicked on the google cache version.  It works for now, but I'm worried that it will go away too..

       

       

       

      • KWildman's avatar
        KWildman
        Copper Contributor

        Hi drusome the VVT cleaner with link to Microsoft docs doesn't even come up in my searches now. I guess there's no way I can find the cached version now, can you comment?

Resources