HELP.

[davidp6442216]

Hi all I have a word document with 6000 names on it which I need to make into a titles style video. Each name should appear on screen then disappear before the next appears. basically I’m looking for some way to copy and paste the entire list to save time. Any help is much appreciated.

[dj.summitt · Accepted solution]

Step 1. Copy and paste the names in to a text file. Eliminate all page breaks and formatting and type a $ between each set of names you want on screen at any moment. The "$" is a delimiter and the subtitles will change there. So use those to break up the text. Save the file to an easy to find location.

Step 2. In After Effects, create one text layer. This text layer will be the titles. Import the finished video.

Step 3. On the text layer, twirl down the settings, then twirl down then "Text" settings, then twirl down the "Source Text"

Step 4. Control+ Click the stopwatch for Source Text and copy paste the following expression:
"type= $.evalFile ("file://c:\\\\Transport_EN.txt");

m = thisLayer.marker.nearestKey(time);

sentences = type.split("$");

n = m.index;

if (time < thisLayer.marker.nearestKey(time).time) {n = n-1};

if (n<1){n=1};

subtitle = sentences;

subtitle"

Change the first line at (file://c:\\\\Transport_EN.txt"); to point to your TXT file.NOTE: As you probably noticed the example I have here is a Windows path. If on Mac use a Mac path. Press Enter. The subtitle should work now.

Step 6.  Create layer markers on the layer where you want the names to change. You may get an error message if there are too few or too many markers on the text layer. Right click to delete any that are extra. Press * on the number pad to add any.

Step 7. If the text box is too large or small double click it to resize. Too much text on screen would be addressed by changing the TXT file though.

[Jose Panadero]

With this product you can automate a task like that:

CompsFromSpreadsheet 5 - aescripts + aeplugins - aescripts.com