CSV “Number of Rows” – adjust automatically in AFX

[Sarah Bartels]

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

[Dan Ebberts]

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]

<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