Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

View MarissaJ's full-sized avatar

FluxVFX MarissaJ

2 followers · 0 following
View GitHub Profile
@MarissaJ
MarissaJ / data-row-number.js
Last active August 24, 2022 02:11
After Effects Data Driven Expressions- Display Data Based on Row Number
n=Math.round(thisComp.layer("Data-Sample.csv")("Data")("Number of Rows"));
values = [];for(i=n-1;i<=n-1;i++)
{     values.push(thisComp.layer("Data-Sample.csv")("Data")("Outline")("Text Data")("Text Data " + i).value); }
values;
@MarissaJ
MarissaJ / smallest-value-spreadsheet-column.js
Last active August 24, 2022 02:10
After Effects Data Driven Expression- Smallest Value in a Spreadsheet Column
values = [];
for(i=0;i<=thisComp.layer("Data-Sample.csv")("Data")("Number of Rows")-1;i++) {   
  values.push(thisComp.layer("Data-Sample.csv")("Data")("Outline")("Number Data")("Number Data " + i).value);
}
Math.min.apply(null, values)
@MarissaJ
MarissaJ / largest-value-column-data.js
Last active August 24, 2022 02:10
After Effects Data Driven Expression- Display Largest Value in a Spreadsheet Column
values = [];
for(i=0;i<=thisComp.layer("Data-Sample.csv")("Data")("Number of Rows")+1;i++) {   
  values.push(thisComp.layer("Data-Sample.csv")("Data")("Outline")("Number Data")("Number Data " + i).value);
}
Math.max.apply(null, values)
@MarissaJ
MarissaJ / data-based-on-time.js
Last active August 24, 2022 02:10
After Effects Data Driven Expression- Display Column Data Based on Time
values = [];
for(i=0;i<=thisComp.layer("Data-Sample.csv")("Data")("Number of Rows")+2;i++) {   
  values.push(thisComp.layer("Data-Sample.csv")("Data")("Outline")("Number Data")("Number Data " + i).value);
} v=values.join(",");
string=v;
array=string.split(",");
l=array.length;
sec=Math.floor(time/effect("Slider Control")("Slider"));
if(sec<l){
@MarissaJ
MarissaJ / column-data-with-spaces.js
Last active August 24, 2022 02:10
After Effects Data Driven Expression- Display Column Data with Spaces
values = [];
for(i=0;i<=thisComp.layer("Data-Sample.csv")("Data")("Number of Rows")-1;i++) {   
  values.push(thisComp.layer("Data-Sample.csv")("Data")("Outline")("Text Data")("Text Data " + i).value);
} values.join(" ");
@MarissaJ
MarissaJ / column-data-line-break.js
Last active August 24, 2022 02:10
After Effects Data Driven Expression- All Column Data with Line Break
values = [];
for(i=0;i<=thisComp.layer("Data-Sample.csv")("Data")("Number of Rows")-1;i++) {   
  values.push(thisComp.layer("Data-Sample.csv")("Data")("Outline")("Text Data")("Text Data " + i).value);
} values.join("\n");
@MarissaJ
MarissaJ / sum-total-data-column.js
Last active August 24, 2022 02:01
After Effects Data Driven Expression- Sum Total Spreadsheet Column Data
rows =thisComp.layer("Data-Sample.csv")("Data")("Number of Rows");
total = 0;
for(i=0;i<rows;i++) {
if(thisComp.layer("Data-Sample.csv")("Data")("Outline")("Number Data")("Number Data " + i))
{
total+= thisComp.layer("Data-Sample.csv")("Data")("Outline")("Number Data")("Number Data " + i);
}
} total;
@MarissaJ
MarissaJ / number-of-times-item-appears-in-column.js
Last active August 24, 2022 02:01
Display number of times an item appears in a spreadsheet column
values = [];
item=thisComp.layer("data 01").text.sourceText.toString();
for(i=0;i<=thisComp.layer("state-gradient.csv")("Data")("Number of Rows")-1;i++) {   
  values.push(thisComp.layer("state-gradient.csv")("Data")("Outline")("Data")("Data " + i).value);
}
values.filter(function(value){
return value === item;
}).length