+ Reply to Thread
Results 1 to 3 of 3

Subtitle to text

  1. #1
    Registered User
    Join Date
    02-14-2016
    Location
    istanbul
    MS-Off Ver
    2010
    Posts
    2

    Subtitle to text

    Hi. I want to make text file from subtitle file (.srt) with macro. For example;

    1
    00:00:06,612 --> 00:00:12,619
    An estimated 20 million cases of blindness
    worldwide are caused by cataracts,

    2
    00:00:12,619 --> 00:00:19,215
    a curable condition affecting the lens
    that focuses images onto the eye's retina.

    3
    00:00:19,215 --> 00:00:23,678
    A cataract occurs when proteins
    in the lens lose their normal arrangement,

    It should be;

    An estimated 20 million cases of blindness worldwide are caused by cataracts, a curable condition affecting the lens that focuses images onto the eye's retina. A cataract occurs when proteins in the lens lose their normal arrangement,

    I want to read as script. I use this macro for it, but I have a problem now. I can't convert other languages excluded English. For example; German, Turkish etc. because this languages has special words. Can you fix the code for me pls?

    Please Login or Register  to view this content.
    Thanks.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,875

    Re: Subtitle to text

    May be the problem is not beacuse of "special words" but because of code page used while saving srt files? Turkish are probably coded with CP 857 or may be 1254 or may be Unicode ???.
    Sample input/expected output related to your problem would help us to properly help you (you gave just English example, while as you wrote - code works fine with English).
    to attach such file, you may for instance zip (compress) it - forum accepts .zip attachments, while .srt is not allowed.
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    02-14-2016
    Location
    istanbul
    MS-Off Ver
    2010
    Posts
    2

    Re: Subtitle to text

    Thank you so much Kaper! I solved the problem The problem is file coding, ANSI instead of UTF-8 Thanks for your help!..

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 12-17-2015, 03:35 AM
  2. Replies: 0
    Last Post: 04-22-2013, 12:13 PM
  3. Change subtitle in left field to above field
    By fara.rhea in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-27-2013, 01:50 AM
  4. [SOLVED] Change subtitle in left field to above field
    By fara.rhea in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-26-2013, 11:48 PM
  5. Macro to Parse Text - Import text to Excel from Multiple Text Files & Folders
    By Novice_To_Excel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-02-2012, 01:05 AM
  6. [SOLVED] Use .text from previous text box in form to prefill text in second text box
    By chromachem in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-23-2012, 10:04 PM
  7. How do I insert a subtitle into a chart?
    By Kellyn in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-17-2006, 04:00 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1