Creative Communities of the World Forums

The peer to peer support community for media production professionals.

Activity Forums Adobe After Effects Expressions Help with CSV Text list

  • Help with CSV Text list

    Posted by Mick Bain on August 25, 2021 at 11:54 am

    Hi.

    I have a csv file with one row of data. There are 1400 words and I am wanting After Effects to show one word at a time per frame. I am new to expressions and have been searching to see if there is a way to do this. I have tried:
    footage(“test.csv”).dataValue([0, timeToFrames(time)+1])

    It is giving me an error saying invalid node index

    Yesterday I had it scrolling through the data but updated the csv file and can’t seem to work out what I have done wrong.

    Do I need a slider to control it? Any help would be greatly appreciated.

    Thanks

    Mick Bain replied 4 years, 11 months ago 2 Members · 4 Replies
  • 4 Replies
  • Fabrice Leconte

    August 25, 2021 at 10:25 pm

    Hello, try this:

    max = thisComp.layer('test.csv')('Data')('Outline').numProperties -1;

    footage('test.csv').dataValue([Math.min(timeToFrames(time),max), 0]);

  • Mick Bain

    August 25, 2021 at 10:57 pm

    Thank you.
    That brings up my first data point but isn’t cycling through, just stays on the first line of text. I’m hoping that text can cycle through one word at a time replacing the previous word. I have 1441 rows in the csv document. Sorry about the newbie questions.

  • Fabrice Leconte

    August 29, 2021 at 3:56 am

    OK for multiple rows, try this:

    perRow = thisComp.layer('test.csv')('Data')('Outline').numProperties;

    numOfRows = thisComp.layer('test.csv')('Data')('Number of Rows');

    if (timeToFrames(time) < perRow * numOfRows) {

    row = Math.min(Math.floor(timeToFrames(time) / perRow), numOfRows - 1);

    col = timeToFrames(time) % perRow;

    footage('test.csv').dataValue([col, row]);

    } else {

    'finished'

    }

  • Mick Bain

    August 31, 2021 at 2:36 am

    Thank you,

    I’ll give that a go. Appreciate your help!

    Cheers

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