-
.csv words cycle in After Effects
I need to cycle through text from a .csv file in After Effects- I have the csv file (originaly-xls) it contains one column with a bunch of cells (peoples names set up as first and last name) I need the comp to change names (cells every frame) Im building a clip to feed into particular to show many employee names- any help would be much appreciated- I’m not very experienced in scripting. I did get the text layer to see the csv file and I see the first name, now I just need it to change to the next line down per frame- Thanks in advance
replied 1 year, 2 months ago 3 Members · 6 Replies
-
6 Replies
-
What does the .csv file look like?
-
It appears that you pulled your .csv file into the timeline, so you should be able to use a Source Text expression like this:
n = thisComp.layer("MCBU Roster for Video copy.csv")("Data")("Number of Rows");
idx = Math.min(timeToFrames(time),n-1);
footage("MCBU Roster for Video copy.csv").dataValue([0,idx]) -
So I need AE to show one name and switch to the next name every frame. from that I will produce a clip to use as a sprite in Trapcode particular like the dummy comp I created. the clip will just be one name center screen in a small comp cycling through all of the names in the list. Thanks for your help
-
Try the expression I posted and see how it goes.
-
Perfect! Exactly what I needed. Some people on other forums had hinted at what I needed to do – add a math expression- index expression etc. but for the script challenged person as my self, I kind of needed someone to spell it out for me. Thank you so much
Ken
-
Thanks for solving this, Dan!
Reply to this Discussion! Login or Sign Up