• Adobe After Effects Expressions

  CSV “Number of Rows” – adjust automatically in AFX

  Posted by Sarah Bartels on April 23, 2020 at 8:07 am

  Hello,
  I have a csv file which the user can fill with two columns and a variable number of rows.
  In my After effects project I want the “Number of Rows” automatically adjust based on the number of values. Is it possible to count the number of values with expression? These are updated with the exchange of the csv file, the “Number of Rows” unfortunately not.

  Thanks a lot,
  Sarah

  Polo Bill replied 4 years, 8 months ago 3 Members · 2 Replies
• 2 Replies

• 

  Dan Ebberts

  April 23, 2020 at 6:42 pm

  If you drag the file into your comp’s timeline, you can get at it like this:

  thisComp.layer(“Values.csv”)(“Data”)(“Number of Rows”)

  Dan
• 

  Polo Bill

  October 22, 2021 at 5:31 pm

  <I was looking for “the number of Rows” max, and “the number of columns” max, from the csv. (dynamic link)

  const data = footage(“Values.csv”).sourceText.split(/\n/);
  const dataFirstRow = data[0].split(“,”);
  //data.length-2 // number of Row
  //dataFirstRow.length-1 // number of Columns

  Polo

Reply to this Discussion! Login or Sign Up