Creative Communities of the World Forums

The peer to peer support community for media production professionals.

Activity Forums Adobe After Effects Expressions .csv words cycle in After Effects

  • .csv words cycle in After Effects

    Posted by Ken Koster on January 31, 2024 at 4:24 pm

    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

    Brie Clayton replied 4 weeks, 1 day ago 3 Members · 6 Replies
  • 6 Replies
  • Dan Ebberts

    January 31, 2024 at 5:49 pm

    What does the .csv file look like?

  • Dan Ebberts

    January 31, 2024 at 6:02 pm

    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])
  • Ken Koster

    January 31, 2024 at 6:05 pm

    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

  • Dan Ebberts

    January 31, 2024 at 6:09 pm

    Try the expression I posted and see how it goes.

  • Ken Koster

    January 31, 2024 at 6:14 pm

    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

  • Brie Clayton

    January 31, 2024 at 11:54 pm

    Thanks for solving this, Dan!

We use anonymous cookies to give you the best experience we can.
Our Privacy policy | GDPR Policy