1
\n00:00:17,794 –> 00:00:22,160
\n“Some of the biggest men in the United States,
\nin the Field of commerce and manufacture are afraid of something.<\/p>\n2
\n00:00:23,873 –> 00:00:28,707
\nThey know that there is a power somewhere so organized,
\nso subtle, so watchful, so interlocked, so complete, so pervasive,<\/p>\n3
\n00:00:30,765 –> 00:00:39,936
\nthat they better not speak above their breath when they speak in condemnation of it.”
\n~Woodrow Wilson, former President of the United States<\/p><\/blockquote>\nSo the basic structure is:<\/p>\n
Subtitle number ID
\nStart time<\/em><\/strong> –><\/em> End time<\/strong><\/em>
\nText of subtitle (one or more lines)<\/strong><\/em>
\nBlank line<\/strong><\/em><\/p>\nThis looked simple enough and so I got to work.<\/p>\n
First thing to sort out was the fields needed. I decided to setup a global field to contain the .srt text and a number field to indicate which line I would like to display\u00a0on top of that I\u00a0then needed\u00a02 calculation fields to create the start and end points of the text for the specific subtitle number ID. Then finally 3 fields needed to be created to display\u00a0start time, end time\u00a0and text in separate fields.<\/p>\n
Using these the plan was to setup a loop which would go through from 1 up to however\u00a0big the last subtitle\u00a0number ID was in\u00a0the .srt text\u00a0– creating a new record for each and extract just the text needed\u00a0and adding it to the previous ID extraction in another global field (of course the loop would simply exit when the calculated text field was empty i.e. end of file).<\/p>\n
At the end you would end up with X records all with the relevant start time, end time and specific text in separate fields (which can be exported to excel) and a global field which can then be copied and pasted in to another application\u00a0with the full\u00a0text from all the IDs.<\/p>\n
There were a few things extra I added to these which I saw from the examples files I was given – that was the use of ” and ~ these were used to start some of the text as quotes and the ~ was used to show who the quote was from. For these I added extra paragraph returns so the text was to some extent better arranged to read.<\/p>\n
The open file is below – just remember to toggle the ” and ~ option if you use it with other .srt files that don’t follow this formatting. Also note that once you have run this process it will automatically export a csv file to your desktop and open it.<\/p>\n
Let me know how you would of chosen to do this and\u00a0any bugs you find? Thanks<\/p>\n
![\"\"](\"https:\/\/simoncpage.co.uk\/blog\/wp-content\/uploads\/2008\/08\/filemaker1.jpg\" "\\"filemaker1\\"")
<\/p>\n