Forums › Adobe After Effects Expressions › CSV “Number of Rows” – adjust automatically in AFX
-
CSV “Number of Rows” – adjust automatically in AFX
-
Sarah Bartels
April 23, 2020 at 8:07 amHello,
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 -
Dan Ebberts
April 23, 2020 at 6:42 pmIf 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 ColumnsPolo
Log in to reply.